dbstudio

Just shipped @dbstudio_sh v2. It now has a desktop app 🔥 Browse tables, edit records, run SQL, and explore your schemas in one place. Free, Open source, with support for Postgres, MySQL, SQLite, MongoDB, Redis, and more.

Your pgAdmin alternative, but actually good, and it works with any database. Introducing db-studio. A free open-source database studio with 18,000 downloads on npm. `npx db-studio` Available today: Databases & connections - PostgreSQL, MySQL, MariaDB, CockroachDB, TiDB, SQL Server, and Oracle - MongoDB, Redis, SQLite, Turso/libSQL, Cloudflare D1, DuckDB, and ClickHouse - Connect with a URL or your project's DATABASE_URL - Save, name, color, and switch between connections Table browser - Spreadsheet-style grid with inline editing - Filter, sort, and paginate rows - Live mode that highlights changed rows and cells on supported engines - Row details with keyboard navigation - Hide and reorder columns, saved per table Records & schemas - Add records with type-aware forms and delete rows - Browse related records and pick foreign key values - Bulk import and export CSV, Excel, and JSON - Create, rename, and delete tables - Manage columns, foreign keys, and indexes Queries & AI - Query editor with syntax highlighting and autocomplete - Save, favorite, and format queries - Table and JSON results with execution time and row counts - Generate, optimize, and fix queries with AI - Ask about your data in plain English using OpenAI, Anthropic, Gemini, Grok, or OpenRouter, with your own API key Developer experience - Runs locally and opens in your browser - Command palette and keyboard shortcuts - Database server logs where available - Light, dark, and system themes - Customizable editor settings and optional anonymous telemetry Free and open source. Apache 2.0.

We are two tickets away from having the desktop app of @dbstudio_sh