whatisgithub

What is db?

positron-labs/db — explained in plain English

Analysis updated 2026-05-18

52Audience · developerComplexity · 2/5Setup · easy

In one sentence

A Windows desktop SQL editor with an AI assistant that understands your database schema.

Mindmap

mindmap
  root((PositronDB))
    What it does
      SQL editor for Windows
      AI writes schema aware queries
      Results grid and history
    Tech stack
      Electron
      Monaco editor
      MySQL Aurora Postgres
    Use cases
      Query a live database
      Get AI help writing SQL
      Manage multiple connections
    Audience
      Developers
      Data analysts
      Windows users

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

What do people build with it?

USE CASE 1

Write and run SQL queries against a MySQL, Aurora, or PostgreSQL database

USE CASE 2

Ask an AI assistant to generate SQL based on your actual table structure

USE CASE 3

Connect to a database behind a bastion host using an SSH tunnel

USE CASE 4

Get a warning before accidentally running a destructive query on production

What is it built with?

ElectronMonacoMySQLAuroraPostgreSQL

How does it compare?

positron-labs/dbadguardteam/corelibsaleksnero/n8n-backup-manager
Stars525252
LanguageJavaScript
Last pushed2024-05-17
MaintenanceDormant
Setup difficultyeasyhardmoderate
Complexity2/54/53/5
Audiencedeveloperdeveloperops devops

Figures from each repo's GitHub metadata at analysis time.

How do you get it running?

Difficulty · easy Time to first run · 30min

Windows 10/11 only, no Mac or Linux support.

License terms were not stated in the README.

So what is it?

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.

Copy-paste prompts

Prompt 1
Help me write a SQL query in PositronDB that joins these two tables using their foreign key relationship
Prompt 2
Show me how to set up an SSH tunnel connection to my production Postgres database in PositronDB
Prompt 3
Explain how PositronDB keeps my database credentials secure
Prompt 4
Walk me through saving and reusing a SQL query I write often

Frequently asked questions

What is db?

A Windows desktop SQL editor with an AI assistant that understands your database schema.

What license does db use?

License terms were not stated in the README.

How hard is db to set up?

Setup difficulty is rated easy, with roughly 30min to a first successful run.

Who is db for?

Mainly developer.

Open on GitHub → Ask about another repo

This repo across BitVibe Labs

Verify against the repo before relying on details.