SoftDB — A modern database management tool for developers

SoftDB is an open-source, free desktop application that helps you connect, explore, and manage databases visually. Runs on Windows, macOS, and Linux.

🗄️ Supports 7 types of databases

PostgreSQL, MySQL, MariaDB, SQLite, MongoDB, Amazon Redshift, and Redis — all in one single application. Browse multiple databases on the same server with a 3-level tree (Connection → Database → Tables).

🤖 Integrated AI Assistant

The AI Assistant powered by OpenAI automatically understands your database schema (tables, columns, data types). Supports real-time streaming, multiple models (GPT-5.3 Codex, GPT-5.4, o4-mini...), and chat history specific to each connection.

🔌 MCP Server — Connect to AI Coding Tools

SoftDB comes with MCP Server integrated with 8 database tools. Allows AI tools like Claude Desktop, Cursor, Windsurf to browse the schema, run queries, and explore your database safely.

✨ Featured Features

• Monaco SQL Editor — Syntax highlighting, automatic column autocomplete, multi-tab

• ER Diagram — Entity relationship diagrams automatically generated from foreign keys

• Query Builder — Build queries using a drag-and-drop interface, no SQL required

• Structure Designer — Create and edit tables visually; MongoDB has a dedicated JSON Schema editor

• SSH Tunneling — Connect to databases via SSH with key or password

• Safe Mode — Block dangerous queries

• Import/Export — Import and export workspace and database (schema + data)

• Query History & Snippets — Save query history and snippets with full-text search

• Dark Mode — A sleek dark interface for long working sessions

🔒 Security

• AES-256-GCM encrypted passwords

• Parameterized queries to prevent SQL Injection

• OAuth PKCE without client secret

• AI/OAuth tokens managed entirely in the backend, never exposed in the frontend

🛠️ Technology

Built with Go + React + TypeScript on the Wails v3 platform, featuring Monaco Editor, TanStack Router/Query, and Tailwind CSS.