Repolode
Submit
husamql3

husamql3/db-studio

Open-source database GUI for SQL, document, and key-value databases, launched with a single npx command.

Open-source alternative to:TablePlusDBeaver

View on GitHubWebsite
Stars
310
Forks
29
Open issues
32
Last commit
12 hours ago

What is it?

db-studio is a browser-based database client that lets you browse tables, edit records, design schemas, and run queries from one interface. It is started with `npx db-studio`, which reads a DATABASE_URL from a local .env file or the environment, or accepts a connection URL pasted into the Connect page.

It covers a wide range of engines, including PostgreSQL, MySQL, SQL Server, Oracle, SQLite, Turso, Cloudflare D1, DuckDB, MongoDB, Redis, and ClickHouse. Saved connections are stored in a local config file under your home directory, and the server binds to 127.0.0.1 by default, with optional host and password settings for network access.

The tool also ships a Docker option, a table grid with inline editing and CSV, Excel, or JSON export, a Monaco-based query editor, and an AI assistant that uses your own API key for Gemini, OpenAI, Anthropic, Grok, or OpenRouter.

Key features

  • 01Connects to SQL, document, and key-value databases through a single connection URL
  • 02Spreadsheet-style table grid with inline editing, filtering, sorting, and pagination
  • 03Live mode highlights changed rows and cells
  • 04Bulk insert from CSV, Excel, or JSON
  • 05Create tables, edit columns, and manage indexes and foreign keys
  • 06Monaco query editor with AI-assisted query generation and fixes

Use cases

  • Quickly inspecting a local development database without installing a desktop client
  • Editing records and exporting tables from SQLite or PostgreSQL during development
  • Browsing MongoDB or Redis data alongside relational databases in one tool
  • Running a shared database studio on a private network with password protection

Quick start

  1. 1

    Run db-studio with npx (no install needed)

    npx db-studio
  2. 2

    Pass a connection URL directly, or paste one on the Connect page

    npx db-studio -d "postgresql://localhost/mydb"

Things to know

  • The server listens on 127.0.0.1 by default, so network access requires extra configuration.
  • AI features need your own API key from a supported provider.

In collections

Databases & SQL tools

Topics

#database-client#database-gui#sql#postgresql#mysql#sqlite#mongodb#redis#clickhouse#cloudflare-d1

FAQ

What is db-studio?
Open-source database GUI for SQL, document, and key-value databases, launched with a single npx command. db-studio is a browser-based database client that lets you browse tables, edit records, design schemas, and run queries from one interface. It is started with `npx db-studio`, which reads a DATABASE_URL from a local .env file or the environment, or accepts a connection URL pasted into the Connect page.
Is db-studio free to use? What license does it have?
db-studio is open source under the Apache-2.0 license. Check the license terms before using it in commercial products.
Is db-studio still maintained?
Actively maintained. The last commit to db-studio was on Nov 6, 2026.
What can I use db-studio for?
Quickly inspecting a local development database without installing a desktop client Editing records and exporting tables from SQLite or PostgreSQL during development Browsing MongoDB or Redis data alongside relational databases in one tool Running a shared database studio on a private network with password protection
How do I install db-studio?
Run db-studio with npx (no install needed): npx db-studio Pass a connection URL directly, or paste one on the Connect page: npx db-studio -d "postgresql://localhost/mydb"
Where can I get db-studio?
The source code and installation instructions are on GitHub: https://github.com/husamql3/db-studio

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects