Open-source database diagrams editor
No installations • No Database password required.

Community • Website • Demo

ChartDB

ChartDB is a powerful, web-based database diagramming editor. Instantly visualize your database schema with a single Smart Query. Customize diagrams, export SQL scripts, and access all features—no account required. Experience seamless database design here.

What it does

• Instant Schema Import: Run a single query to instantly retrieve your database schema as JSON. This makes it incredibly fast to visualize your database schema, whether for documentation, team discussions, or simply understanding your data better.
• AI-Powered Export for Easy Migration: Our AI-driven export feature allows you to generate the DDL script in the dialect of your choice. Whether you’re migrating from MySQL to PostgreSQL or from SQLite to MariaDB, ChartDB simplifies the process by providing the necessary scripts tailored to your target database.
• Interactive Editing: Fine-tune your database schema using our intuitive editor. Easily make adjustments or annotations to better visualize complex structures.

Status

ChartDB is currently in Public Beta. Star and watch this repository to get notified of updates.

Supported Databases

• PostgreSQL
• MySQL
• SQL Server
• MariaDB
• SQLite

Getting Started

Use the cloud version or deploy locally:

How To Use

bash
npm install
npm run dev

Build

bash
npm install
npm run build

Or like this if you want to have AI capabilities:

bash
npm install
VITE_OPENAI_API_KEY=YOUR_OPEN_AI_KEY npm run build

Running the Docker Container

bash
docker build -t chartdb .
docker run -p 8080:80 chartdb

Open your browser and navigate to http://localhost:8080.

Try it on our website

1. Go to ChartDB.io
2. Click Go to app
3. Choose the database that you are using.
4. Take the magic query and run it in your database.
5. Copy and paste the resulting JSON set into ChartDB.
6. Enjoy Viewing & Editing!

Community Support

• Discord (For live discussion with the community and the ChartDB team)
• GitHub Issues (For any bugs and errors you encounter using ChartDB)
• Twitter (Get news fast)

Contributing

We welcome community contributions, big or small, and are here to guide you along the way. Message us in the ChartDB Community Discord. For more information on how to contribute, please see our Contributing Guide. This project is released with a Contributor Code of Conduct. By participating in this project, you agree to follow its terms. Thank you for helping us make ChartDB better for everyone: heart.

License

ChartDB is licensed under the GNU Affero General Public License v3.0.

Understanding ChartDB

Think of ChartDB as a high-tech map-making tool for your databases. Just like an explorer uses a compass and a map to understand the terrain they’re going to traverse, ChartDB provides you with an intuitive interface to visualize the structure and relationships within your database. You give it a simple command (like a magic spell), and it reveals the entire layout of your data-world, so you know where to go, what to explore, and how to interact with the landscape of your information.

Troubleshooting Ideas

If you encounter any issues, consider the following troubleshooting steps:

• Ensure all your commands are typed correctly.
• Check your internet connection if using the cloud version.
• Refer to the GitHub Issues page for known issues.
• If you need further assistance, don’t hesitate to join our Discord community.

For more insights, updates, or to collaborate on AI development projects, stay connected with fxis.ai.

At fxis.ai, we believe that such advancements are crucial for the future of AI, as they enable more comprehensive and effective solutions. Our team is continually exploring new methodologies to push the envelope in artificial intelligence, ensuring that our clients benefit from the latest technological innovations.