What is the Database Studio?

The Database Studio is a browser-based SQL client for PostgreSQL. It lets you connect to any Postgres database, explore schemas, run queries, and inspect data — without installing a desktop application like pgAdmin, TablePlus, or DBeaver.

It works with any PostgreSQL database: a local development instance, a cloud-hosted database on Neon, RDS, Supabase, PlanetScale, or a private staging environment reached via a secure tunnel.

How it works

There are two connection modes. With a managed database, you create a Neon PostgreSQL instance directly from your account — credentials are configured automatically and the studio connects immediately. With a tunnel connection, you run the 1tt CLI on your machine, which opens a WebSocket proxy to the studio. Queries are relayed through the tunnel and executed locally — no data leaves your environment.

How to use this tool

• Create a managed database — go to your account, create a Neon database, and open the studio in one click
• Connect via tunnel — generate a tunnel token, install the 1tt CLI, and run 1tt tunnel --token ... --db postgres://...
• Browse the schema — explore tables, columns, indexes, and foreign keys in the sidebar
• Run SQL queries — write and execute queries with syntax highlighting and result pagination
• Inspect and edit rows — view, insert, update, and delete records directly from the table view

Common use cases

• Querying a local development database without installing a GUI client
• Exploring a staging or production database schema while onboarding to a new codebase
• Running SELECT queries to debug data issues or verify migrations
• Browsing a Neon or Supabase database from any device without extra tooling
• Teaching SQL interactively — spin up a fresh database and explore it in real time