Welcome

NeoSQL is a database development platform that unifies ERD modeling, multi-DBMS schema management, SQL execution, and AI-powered automation in a single tool.

About NeoSQL

NeoSQL brings together every step of database development — ERD design, database connections, SQL execution, schema change tracking, team collaboration, and AI automation — into a single tool. It supports major RDBMSs including MySQL, PostgreSQL, Oracle, and SQL Server, and delivers the same experience across three environments: web browser, desktop app (online), and air-gapped desktop (offline). It scales from personal side projects to team-wide management of production databases.

Why NeoSQL

There are many ERD tools out there, but NeoSQL closes the loop across AI automation, bi-directional engineering, code generation, multi-environment UX, and operational safety in a single product. Tasks that would normally require installing extra plugins or wiring up separate systems happen seamlessly inside NeoSQL with no additional setup.

AI Drives Your Database Directly — Built-in MCP

Plug MCP-compatible AI clients such as Claude Code, Codex, and Gemini straight into NeoSQL to design and modify tables in natural language, or translate plain-English questions into SQL and execute them. Because the MCP server is bundled inside NeoSQL itself, there are no plugins to install and no config files to write — and the AI can only operate within the connections and schemas you authorize.

Bi-directional ERD — Forward · Reverse · Live DDL

Auto-extract an ERD from an existing database (Reverse), and turn ERD changes back into DDL to apply against the real database (Forward). ERD and DB stay synchronized in a single flow, with automatic handling of partial apply, table-name collisions, FK impact from PK changes, and DROP/RENAME impact analysis.

Built-in Code Generation + Template Pack Marketplace In Dev

Generate Entities, Repositories, DTOs, services, and full CRUD screens from your table definitions using full Velocity-based templates. Beyond the official template packs, the marketplace offers ready-made packs per language and framework, dramatically shortening the distance from ERD to production code.

Desktop (Online) · Web · Air-gapped (Offline) — Same UX

The web browser, online desktop app, and offline desktop app deliver the same screens, the same shortcuts, and the same feature set. Try things out on the web, collaborate as a team on the online desktop, run on the offline desktop in air-gapped networks — without switching tools or relearning the product, which makes enterprise adoption a much simpler decision.

Zero-Knowledge Encryption · Connection Privacy · DDL Approval — Production Safety Net

Database credentials are encrypted on the client before being stored, so the server never sees the plaintext. Connection visibility can be limited to owner-only or shared with the team, and SQLite, H2, and localhost connections are automatically marked private. Production DDL can be put behind an approval flow before it runs, reducing the risk of mistakes against live databases.

NeoSQL at a Glance

A quick reference for how far NeoSQL reaches. Detailed capabilities are covered in Key Features and the individual guides below.

8 Supported DBMSs — PostgreSQL · Supabase · MySQL · MariaDB · Oracle · SQL Server · SQLite · H2 — convert the same ERD into the DDL of any DBMS.
ERD · SQL · Code Gen · AI in One Workspace — Work continues inside a single workspace, without switching tools.
From Solo Developer to Team & Enterprise — Permissions are split across four roles — Owner · Manager · DBA · Member — all covered by the same tool.
Public Gallery — Browse ERDs published by other users, and fork designs you like into your own project to learn from and reuse.

Take a Tour

Take a quick visual tour of the main areas of NeoSQL — from ERD modeling to SQL execution, code generation, and the public gallery.

ERD Canvas

The main workspace where you design tables, columns, and relationships via drag & drop, and tidy up your ERD with auto layout, color, and style options.

SQL Editor & Result Grid

Run queries in a SQL editor with auto-complete and multiple tabs, and review results in a grid or export them as CSV / JSON.

Code Generation Panel In Dev

Generate entities, repositories, DTOs, and CRUD screens from your table definitions in one go using Velocity templates.

Gallery / Embed Viewer

Browse ERDs published by other users in the public gallery, and embed your own ERDs into external pages for lightweight sharing.

Key Features

Get a quick overview of what NeoSQL offers — from ERD modeling and schema comparison to multi-DBMS dialect conversion and AI automation.

📐

ERD Editor

Design tables, columns, indexes, and constraints with drag & drop, and visualize 1:N, 1:0..N, and N:N relationships. Includes dagre-based auto layout and per-table color and style customization.

🔄

Reverse / Forward Engineering

Connect to an existing database to auto-extract tables and relationships into an ERD, or generate DDL from your ERD to apply to a real database. Multi-select lets you sync only the tables you want.

⚡

Auto DDL Generation

Track changes in your ERD and automatically generate ALTER / CREATE / DROP statements. Safely handles table-name collisions, FK impact from PK changes, and column type conversions.

🔍

Schema Comparison

Compare two database schemas side by side to visualize differences in tables, columns, PKs, FKs, and indexes, then generate sync DDL to apply to the target. Source and Target can be swapped freely, making it useful for diffing dev and production databases.

🔀

Multi-DBMS Dialect Conversion

Convert the same ERD into DDL for MySQL, PostgreSQL, Oracle, SQL Server, and more. NeoSQL automatically maps differences in data types, reserved words, and syntax across DBMSs.

🖼️

ERD Visual Export

Export your ERD as a PNG or SVG image, or copy it to the clipboard for instant use in documents and presentations. Capture either the entire ERD or just the current viewport.

🗄️

SQL Editor

Write and run queries in the built-in SQL editor and inspect results in a grid. Supports auto-complete, syntax highlighting, multiple tabs, EXPLAIN plans, and transaction control.

🤖

AI Support (MCP)

Connect MCP-compatible AI clients such as Claude Code, Codex, or Gemini to NeoSQL to design and modify tables in natural language, or translate plain-English questions into SQL and execute them.

👥

Real-time Team Collaboration

In online mode, cloud-based real-time sync lets your team work on the same ERDs and queries together, with per-project roles and change history.

🔐

Security

Database credentials are encrypted on the client before being stored, and connection visibility can be limited to owner-only or shared with the team. SQLite, H2, and localhost connections are automatically marked private.

Supported Databases

NeoSQL supports a wide range of relational databases.

PostgreSQL

Supabase

MySQL

MariaDB

Oracle

SQL Server

SQLite

NeoSQL automatically recognizes each DBMS's native data types (MySQL JSON, PostgreSQL ARRAY / JSONB, Oracle NUMBER / CLOB, etc.), sequences, functions, reserved words, and index options, and handles them accordingly. When converting the same ERD to another DBMS, incompatible types are mapped to the closest equivalent.

Tip

For environments that require firewall traversal or certificate-based security, NeoSQL supports SSL/TLS connections and SSH tunneling. See the Advanced Connection page in the left menu for detailed setup.

Choose Your Environment

NeoSQL supports three execution environments. Choose the one that fits your needs.

🌐

Web

Use directly in your browser. No installation required, runs in online mode.

No installation needed
Online collaboration
Cross-platform

💻

Desktop + Online

Install the desktop app and log in with online mode. Use cloud sync and collaboration features.

Cloud sync
Team collaboration
Direct local DB connection

🔒

Desktop + OfflineNEW

For air-gapped environments. Store data locally without internet connection.

No internet required
Local file storage
Air-gapped support

Which Environment Should You Choose?

The best execution environment depends on how you plan to use NeoSQL. Use the guide below to pick the mode that fits your workflow.

Just trying NeoSQL or want to explore quickly → Web mode

Open NeoSQL directly in your browser with no install required and try out ERD modeling and SQL execution. A good fit for connecting to public or test databases, or exploring the main features with a sample ERD.

Working on production databases with a team → Desktop + Online

Production databases are typically only reachable from developer machines, so the desktop app connects to them directly from your local environment. At the same time, cloud sync keeps ERDs and queries shared with your team in real time — this is the most common choice.

Working in an air-gapped or offline environment → Desktop + Offline

Runs entirely on a license key in networks with no internet access. All data is stored on the local file system (.neosql/) with no communication to external servers, making it suitable for finance, government, defense, and other strictly regulated environments.