A modern, universal database studio (the pgAdmin alternative) for every database.
Browse tables, edit records, design schemas, and run queries from one UI, launched with a single npx command.
No installation required:
npx db-studiodb-studio searches the current directory, then its parents, for a .env file with DATABASE_URL, then the environment. Without one, open the printed address and paste a connection URL on the Connect page.
Every connection that opens is saved to ~/.dbstudio/connections.json, readable only by your user, so you can switch between them from the sidebar. The server listens on 127.0.0.1 only; to serve it on your network, set HOST and list the hostname or IP you connect through in ALLOWED_HOSTS.
You can also run db-studio as a Docker container. Simply run:
docker build -t db-studio .
docker run --rm -p 127.0.0.1:3333:3333 -v db-studio-config:/home/node/config db-studioCheck Running db studio with Docker to learn more and customize the container.
As a project script:
{
"scripts": {
"db:studio": "npx db-studio"
}
}Flags:
| Flag | Description | Example |
|---|---|---|
-e, --env <path> |
Use a specific .env file |
npx db-studio --env .env.local |
-n, --var-name <name> |
Read a different environment variable | npx db-studio --var-name MY_DB_URL |
-p, --port <number> |
Change the server port (default: 3333) | npx db-studio --port 4000 |
-d, --database-url <url> |
Pass the connection string directly | npx db-studio -d "postgresql://localhost/mydb" |
--open |
Open db-studio in your browser once it starts | npx db-studio --open |
--no-open |
Do not open the browser (the default) | npx db-studio --no-open |
-s, --status |
Check the connection only, without the UI | npx db-studio --status |
-v, --version |
Show the installed version | npx db-studio --version |
-h, --help |
Show all options | npx db-studio --help |
Full documentation: dbstudio.sh
- 🐘 PostgreSQL, CockroachDB, MySQL, MariaDB, TiDB, SQL Server, Oracle
- 🪶 SQLite, Turso / libSQL, Cloudflare D1, DuckDB
- 🍃 MongoDB, Redis, ClickHouse
- 🔌 Connect with a single connection URL
- 📋 Spreadsheet-like grid with inline cell editing
- 🔎 Filter, sort, and paginate rows
- 🔴 Live mode refreshes the grid and highlights changed rows and cells
- 🧾 Row details sheet with keyboard navigation between rows
- 🙈 Hide and reorder columns, saved per table
- 📤 Export tables as CSV, Excel, or JSON
- ➕ Add records with type-aware forms
- 📥 Bulk insert from CSV, Excel, or JSON
- 🔗 Pick foreign key values from the referenced table
- 🗑️ Delete rows, with force delete for dependent rows
- 🏗️ Create and rename tables, with foreign keys
- ✏️ Add and edit columns
- 📇 Create and drop indexes
- ⌨️ Monaco-powered editor with syntax highlighting and autocomplete
- ✨ Generate, optimize, or fix queries with AI
- 💬 Ask questions about your data in plain English
- 🔑 Bring your own key for Gemini, OpenAI, Anthropic, Grok, or OpenRouter
- ⌘ Command palette to jump to tables and run actions
- 🌗 Light and dark themes
- 📊 Anonymous usage data, off with
DB_STUDIO_TELEMETRY=0
See CONTRIBUTING.md for development setup. Check the roadmap and changelog for what's planned and what shipped.
Apache License 2.0 - see LICENSE.