NeoSQL - A DB Workbench Integrating ERD, SQL Editor, and Code Generation (+ AI MCP Support)

NeoSQL, which integrates ERD modeling, SQL editing, and code generation into a single tool, has been released. It supports both desktop (Windows/macOS) and web environments, providing a consistent workflow from DB design to operations and AI integration.

Key Features

• ERD Modeling: Automatic ALTER DDL generation through Forward/Reverse Engineering and schema change tracking
• SQL Editor: Auto-completion and execution plan support, with Manual Commit set as default to prevent data accidents
• Schema Diff: Compare schema differences between dev/staging/production DBs and selectively apply changes
• Automatic Code Generation: Supports various languages and frameworks such as Java, Python, TypeScript via Velocity-based templates (in development)

AI and Security-Specific Features

• AI MCP Support: Built-in MCP (Model Context Protocol) server for safely handling ERD and SQL in Claude, Cursor, VS Code, etc.
• Human-in-the-loop: Instead of AI directly issuing commands to the DB, changes are first reflected in the ERD, then applied after user review and approval
• Strong Security: Connection information is encrypted and stored using AES-256-GCM, designed so that passwords are not exposed in the AI context
• Collaboration and Permission Management: Provides role-based access control (RBAC) and a DDL approval workflow to prevent unauthorized changes to production DBs