positron-labs/db

PositronDB is a desktop SQL workbench for Windows, built as a native app using Electron. It is designed for developers and analysts who want to write and run SQL queries against MySQL, Aurora, or PostgreSQL databases while getting help from an AI assistant that knows their specific database structure. The core editor uses Monaco, the same editor that powers VS Code, and provides completion and hover documentation for your specific tables, columns, and relationships rather than generic SQL keywords. You can have multiple tabs open, open and save .sql files, format SQL with a built-in formatter, and run queries with Ctrl+Enter. A results grid shows the output, and query history plus saved queries are kept between sessions. The AI assistant reads your live schema, identifies the tables most relevant to your question, follows foreign-key relationships, and writes SQL specific to your actual data rather than generic boilerplate. Proposed SQL can be inserted into the current editor tab with one click. Conversations are saved and searchable, and each thread shows a token count so you can track what the AI assistance is costing. The connection manager handles multiple connections, including SSH tunnel support for databases behind a bastion host. Production connections are flagged with a warning that fires before you run a destructive statement. Passwords, SSH keys, and API keys are stored using the OS keychain rather than plain config files. Editor completion and hover work entirely on your machine without sending keystrokes to any external service. The app ships with automatic updates, light and dark themes, and resizable panes. It currently runs only on Windows 10 and 11.