A database GUI that lives in your browser
Most PostgreSQL clients — pgAdmin, DBeaver, DataGrip — are desktop apps that need to be installed, updated, and configured. The 1tt.dev Database Studio runs entirely in the browser. Open a tab, paste a connection string, and start querying.
Connecting
Connections use a standard PostgreSQL connection string:
postgresql://user:password@host:5432/dbname
The connection is proxied through the 1tt.dev backend so your database does not need to allow browser-origin CORS requests. As long as the host is reachable from the internet (or from your network if you are connecting to a local instance), it will work.
Schema browsing
Once connected, the sidebar lists all schemas and their tables. Click any table to open it in a new tab with:
- Column names, types, nullability, and default values
- Primary keys, foreign keys, and unique constraints
- Indexes with their type and columns
- Row counts and a paginated data preview
The tab bar keeps multiple tables open at once so you can cross-reference schemas without losing your place.
SQL editor
The built-in SQL editor gives you a full query workspace with syntax highlighting and keyboard shortcuts. Results render in a sortable, scrollable data grid. You can run SELECT, INSERT, UPDATE, DELETE, and DDL statements — anything your database user has permission to execute.
AI-assisted SQL
Not sure how to write a query? The studio includes an AI assistant that generates SQL from plain English. Describe what you want — "show the 10 most recent orders with customer names" — and the assistant writes the query for you, using the actual tables and columns in your database.
- Schema-aware — the AI sees your database schema so it produces queries that reference real table and column names, not guesses
- Suggestion chips — contextual query suggestions appear based on your schema, giving you one-click starting points for common queries
- Edit and refine — generated SQL is placed directly in the editor where you can review, modify, and run it
Hosted Postgres databases
Don't have a database yet? 1tt.dev can provision a hosted PostgreSQL instance for you. Each hosted database runs on dedicated infrastructure managed by 1tt — no AWS console, no Terraform, no connection pooler to configure. You get a connection string and start building.
- Instant provisioning — create a new database in seconds from the Database Studio interface
- Managed backups — automated daily backups with point-in-time restore
- Built-in studio access — your hosted database appears directly in the Database Studio sidebar, ready to browse and query
- Standard Postgres — full PostgreSQL compatibility. Use it from any client, ORM, or migration tool that speaks Postgres
Hosted databases are included with Pro and Max plans. You can also connect your own external databases alongside hosted ones — the studio treats them the same way.
When to use it
- Quick checks — verify data after a migration, inspect a staging database, or confirm a deploy without opening a full desktop client
- Remote debugging — connect from any machine with a browser, no SSH tunnel or local tooling required
- Pair programming — share your screen and walk through schemas and queries without requiring your teammate to install anything
- Cloud databases — works with any Postgres-compatible service: Supabase, Neon, Railway, Amazon RDS, Google Cloud SQL, Azure Database for PostgreSQL