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
Completed- Develop CLI tool for running the db studio app
- Publish the tool on npm and release it
Core Views & Tabs
In Progress- SQL editor with run button and results table
- Built-in AI helper for writing, explaining, and improving SQL
- Edit table columns directly from the schema tab, including add, rename, update, and drop actions
- Indexes section to view, add, edit, remove, and understand indexes
- Interactive ER diagram with relationship navigation and join query generation
- Schema section for views, functions, triggers, and extensions
- Safe query mode with transaction preview, commit, and rollback
- Explain plan viewer for understanding query performance
- Save favorite queries and view recent query history
- Query workspace with saved files, snippets, variables, and database context
- Smart SQL editor with color coding, auto-complete, and formatting
Data Management Improvements
In Progress- 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
- Bulk edit rows, clone records, and preview pending changes before saving
- Advanced import/export pipelines with column mapping, type inference, invalid-row preview, and reusable presets
- Compare table data or query results and highlight differences
- 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
- Support for adding personal AI provider credentials (OpenAI, Anthropic, etc.)
- Suggest faster ways to write queries, explain plans, 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
- Generate migration drafts from schema changes with human review
- AI chat sidebar scoped to the selected database
Multi-Database Support
In Progress- Add full support for PostgreSQL databases
- Add full support for MySQL databases
- Add full support for SQL Server databases
- Add full support for MongoDB databases
- Add full support for SQLite databases
- Add full support for MariaDB databases
- Add full support for Oracle databases
- Add support for Redis and Valkey key-value databases
- Add support for DuckDB and ClickHouse analytics databases
- Add support for Elasticsearch and OpenSearch databases
- Easy switching between different database connections
Platform Availability
Planned- Native desktop apps for macOS, Windows, and Linux
Database Operations
Planned- Deep object explorer for views, functions, triggers, constraints, sequences, users, roles, and permissions
- Saved connection manager with SSH tunnels, SSL/TLS, env vars, and templates
- Connection health checks with clear diagnostics and reconnect actions
- Schema drift detection between environments
NoSQL Tools
Planned- Redis and Valkey key browser with TTL, memory usage, and data structure viewers
- MongoDB collection schema inference, aggregation builder, and document diff
- Elasticsearch and OpenSearch index explorer, mappings viewer, and query builder
Advanced Tools
Planned- Drag-and-drop visual tool to build queries without writing SQL
- Compare database structures and generate migration scripts
- Turn query results into charts directly in the app
- Review schema changes before applying them to production databases