chartdb
Database diagrams editor that allows you to visualize and design your DB with a single query.
What is chartdb?
Database diagrams editor that allows you to visualize and design your DB with a single query.
Overview of chartdb
What it is
ChartDB is an open-source, web-based database diagramming editor. It allows users to visualize and design their database schema with a single query. No installation or database password is required. The project is currently in Public Beta.
Key features
- Instant Schema Import: Run a single query to retrieve the database schema as JSON.
- AI-Powered Export: Generate DDL scripts in the dialect of your choice for database migration.
- Interactive Editing: Fine-tune and annotate the database schema using an intuitive editor.
- No account required: All features are accessible without creating an account.
- Privacy-focused analytics via Fathom Analytics, which can be disabled.
Use cases
- Visualizing existing database schemas for documentation or understanding.
- Designing and editing database schemas collaboratively.
- Migrating between different database systems (e.g., MySQL to PostgreSQL) using AI-generated DDL scripts.
- Teaching or learning database schema design.
Getting started
Use the cloud version at ChartDB.io or deploy locally. For local deployment: bash npm install npm run dev To build: bash npm install npm run build With AI capabilities: bash npm install VITE_OPENAI_API_KEY= npm run build Run with Docker: bash docker run -e OPENAI_API_KEY= -p 8080:80 ghcr.io/chartdb/chartdb:latest For custom inference server, see the repository README.
License and pricing
ChartDB is licensed under the GNU Affero General Public License v3.0 (AGPL-3.0). It is open source and free to use.
Based on the project's public README and repository metadata.