Introduction
Welcome to DBStudio - The Modern Database Workspace
DBStudio
DBStudio is an all-in-one database management and visualization workspace designed for modern development workflows. Whether you're a solo developer or part of a large team, DBStudio provides the tools you need to interact with your data effectively.
Key Features
Multi-Database Support
MySQL, PostgreSQL, and SQLite support with local and remote connections.
Table Explorer
Browse tables, view/edit rows, inspect indexes, and understand relationships.
Query Editor
Full-featured SQL editor with autocomplete, history, and export capabilities.
AI Copilot
Optimize, explain, and discuss queries with state-of-the-art AI models.
Natural Language to SQL
Write queries in plain English and let AI generate optimized SQL.
Data Visualizer
Transform query results into charts with AI-suggested data analysis.
ERD Visualizer
Interactive entity-relationship diagrams with sticky notes and auto-layout.
Schema Builder
Generate Drizzle or Prisma schemas from your database—no AI needed.
API Generator
Auto-generate Next.js API routes for every table in your database.
Version History
Snapshot your workspace state, view diffs, and restore previous versions.
Collaboration
Built for teams from the ground up:
Team Workspaces
Personal and shared workspaces with role-based access control.
Team Chat
Real-time messaging with resource tagging and @mentions.
Contextual Comments
Discuss queries and ERDs directly in context with your team.
Webhooks & Integrations
Connect to Slack and Discord for real-time activity notifications.
Architecture
DBStudio uses a hybrid architecture to balance security and convenience:
- CLI Agent: A lightweight Node.js utility you run locally. It connects to your database and establishes a secure WebSocket bridge to our server.
- Server: A high-performance gateway that orchestrates sessions, manages AI context, and handles team collaboration features.
- Web Interface: A responsive, TanStack-powered dashboard where you manage all your database assets.
AI Tooling
DBStudio exposes an llms.txt and llms-full.txt that helps AI models understand how to interact with your documentation and database tools.
Support
DBStudio supports the transition between local development and remote production seamlessly across:
- PostgreSQL
- MySQL
- SQLite / Turso