DB Studio

Product Roadmap

Follow our journey as we build the future of database management

Foundation

Completed
  • Solid connection to PostgreSQL databases
  • Easy browsing of tables with full details
  • Clear view of how tables are structured
  • Modern, spreadsheet-style interface
  • Fast filtering and sorting of data
  • Simple way to create new tables and add rows

Release & Distribution

Planned
  • Publish the tool on npm and set up regular releases

Core Views & Tabs

Planned
  • SQL editor with run button and results table
  • Built-in AI helper for writing, explaining, and improving SQL
  • Indexes section to view, add, edit, or remove indexes
  • Interactive diagram showing table relationships (ER diagram)
  • Schema section for views, functions, triggers, and extensions
  • Safe playground area to test queries without risk
  • Save favorite queries and view recent query history
  • Smart SQL editor with color coding, auto-complete, and formatting

Data Management Improvements

Planned
  • Import many rows at once using CSV or JSON files
  • Smart dropdowns for related tables with search and easy navigation
  • Export and import both data and database structure
  • Better JSON editor inside cells with formatting and line numbers
  • Customize the grid: hide/reorder columns and add color rules

AI-Powered Features

Planned
  • Turn plain English into accurate SQL using knowledge of your full database
  • Explain any SQL query in simple, everyday English
  • Suggest faster ways to write queries and show how much quicker they’ll run
  • Help design tables and suggest smart improvements to your database structure
  • Ask questions about your data in normal English and get instant answers
  • Spot errors in failed queries and suggest quick fixes

Multi-Database Support

Planned
  • Add full support for MySQL databases
  • Add full support for SQLite databases
  • Easy switching between different database connections
  • Support for multiple open connections at the same time

Platform Availability

Planned
  • Native desktop apps for macOS, Windows, and Linux

Advanced Tools

Planned
  • Drag-and-drop visual tool to build queries without writing SQL
  • Compare database structures and create update scripts
  • Turn query results into charts directly in the app
  • Secure connections using SSH tunnels and SSL/TLS encryption