drawDB
Schema design with no account and a few clicks: drawDB is the browser-based entity-relationship diagram editor and SQL generator - an AGPL-3.0 React project with over 37,000 GitHub stars. Draw tables with columns, data types, defaults, and constraints; connect fields to create foreign-key relationships; group tables into labeled subject areas; and annotate with notes. When the design is ready, one export produces CREATE TABLE DDL - with constraints, indexes, and foreign keys - targeted at MySQL, PostgreSQL, SQLite, MariaDB, SQL Server, or Oracle. Diagrams can be database-specific, unlocking every native type plus dialect features like PostgreSQL enums and composite custom types, or generic for portability across all supported flavors. The reverse direction works too: paste existing DDL into the import dialog and drawDB renders your live schema as a navigable diagram - the fastest way to document an inherited database. Versioning and migration-script generation track schema evolution, full editor ergonomics (undo/redo, copy/paste, duplicate, themes) keep iteration fast, and diagrams export as PNG, SVG, or shareable JSON. Everything runs client-side against browser storage - no backend database connection needed - so the self-hosted Docker deployment is a featherweight static app that keeps proprietary schema designs entirely on your infrastructure.
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.
Azimutt
Inheriting a sprawling database with hundreds of undocumented tables usually means weeks of guesswork, unless you open it in Azimutt to visually map schemas, trace relationships, and inspect live rows in one workspace. Instead of dumping every table onto a cluttered canvas that crashes your browser, the visual explorer starts clean so you can search across entity names, column types, and SQL comments to reveal only the tables relevant to your investigation. Clicking foreign-key or primary-key indicators expands incoming and outgoing relations step by step, while the graph path-finder automatically calculates the shortest join route between any two distant entities. When debugging production issues or answering support tickets, you can query live records across PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite, MongoDB, Couchbase, Snowflake, and BigQuery, then click directly through foreign keys in the result rows to follow data lineage visually. Architects and developers also design new schemas at typing speed using Azimutt Markup Language (AML), attach contextual markdown notes, tags, and memos to saved layouts for team onboarding, and run automated schema analysis that flags missing primary keys, implicit foreign keys, inconsistent column types, and oversized tables. Running on a dedicated VPS on RepoCloud with guaranteed CPU, RAM, and SSD, full root SSH access, and a browser serial console. MIT licensed.
StackRender
To design relational database schemas visually and generate production-ready SQL migrations without writing boilerplate DDL by hand, developers use StackRender, an interactive browser-based schema modeling studio. Users can start from a blank drag-and-drop Entity Relationship Diagram canvas or import existing SQL DDL scripts directly from PostgreSQL, MySQL, MariaDB, SQLite, Oracle, and Microsoft SQL Server databases. Each table node provides granular control over column data types, lengths, precision, character sets, collations, nullability, uniqueness, primary keys, composite indexes, and custom PostgreSQL enum types. When connecting tables across one-to-one, one-to-many, and many-to-many relationships, the schema analyzer checks for circular foreign key dependencies and suggests performance indexes on frequently joined columns. As a schema evolves over time, the visual state-diff engine records every structural modification and generates paired UP forward-migration and DOWN rollback scripts, accurately translating table and column renames into non-destructive ALTER statements rather than dropping and recreating data. Running on a dedicated VPS on RepoCloud with guaranteed CPU, RAM, and SSD, full root SSH access, and a browser serial console. AGPL-3.0 licensed.