Logo
Deploy Now

SaaS Alternative

Lucidchart dbdiagram.io

Categories

Developer Tools AI Database SQL Diagramming Visualization Schema Design

Stars

22,763

Forks

1,471

Watchers

84

Developer links

Last Updated: 08-24-2026 03:29 AM (UTC)

ChartDB

Paste one SQL query result into a browser and get an interactive entity-relationship diagram instantly, with no installations, no credentials, and no account required. ChartDB's "Smart Query" runs a single statement in your existing database client that exports table definitions, relationships, indexes, and column types as JSON metadata, meaning the application never touches your database passwords. The canvas renders draggable entities with cardinality markers, collapsible grouping areas, and sticky notes for documentation. AI-powered DDL export generates migration scripts between dialect pairs like PostgreSQL to MySQL or SQLite to CockroachDB, analyzing your schema to produce target-specific DDL with correct type mappings and constraint translations. Import paths cover Smart Query JSON, raw DDL scripts, and DBML files from tools like dbdiagram.io. The AI layer connects to OpenAI or any compatible inference server including local vLLM instances running models like Qwen2.5-32B. Database coverage includes PostgreSQL (with Supabase and Timescale extensions), MySQL, SQL Server, MariaDB, SQLite (with Cloudflare D1), CockroachDB, ClickHouse, and Oracle. Exports to SVG with inline styles or SQL DDL in any target dialect. Ships as a React/Vite frontend behind Nginx in Docker, deployable on RepoCloud with dedicated VPS resources under the AGPL-3.0 license.

ChartDB
ChartDB
ChartDB
ChartDB
ChartDB

Benefits

  • Zero Credential Schema Import
  • Smart Query extracts complete schema metadata as JSON from your database client without ever sending credentials to ChartDB, keeping authentication entirely within your control.
  • AI Cross-Dialect DDL Migration
  • Generate migration scripts between PostgreSQL, MySQL, SQL Server, MariaDB, SQLite, CockroachDB, and ClickHouse with automatic type mapping and constraint translation.
  • Instant Browser-Based Visualization
  • No installations, accounts, or plugins required. Paste JSON from any supported database engine and see interactive entity-relationship diagrams rendered immediately in your browser.
  • Custom LLM Endpoint Support
  • Connect to OpenAI, or point to any OpenAI-compatible inference server including local vLLM instances running open models like Qwen2.5-32B for fully private AI-powered operations.

Features

  • Smart Query Import
  • Single SQL query extracts complete schema including tables, relationships, indexes, check constraints, and views as JSON for instant diagram rendering.
  • Interactive Diagram Editor
  • Drag-and-drop canvas with connection lines, cardinality markers, collapsible areas, sticky notes, and SVG export with inline styles.
  • Multi-Dialect Database Support
  • PostgreSQL, MySQL, SQL Server, MariaDB, SQLite, CockroachDB, ClickHouse, and Oracle with Supabase, Timescale, and Cloudflare D1 extensions.
  • Multiple Import Formats
  • Import schemas via Smart Query JSON output, DDL scripts in any supported dialect, or DBML files from tools like dbdiagram.io.
  • AI-Powered DDL Export
  • LLM-driven generation of migration scripts between any pair of supported database dialects with intelligent type conversion and constraint handling.