gitwtfhub

wtf is db?

positron-labs/db — explained in plain English

Analysis updated 2026-05-18

52Audience · developerComplexity · 2/5Setup · easy

TL;DR

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

Why would anyone build with this?

REASON 1

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

REASON 2

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

REASON 3

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

REASON 4

Get a warning before accidentally running a destructive query on production

What's in the stack?

ElectronMonacoMySQLAuroraPostgreSQL

How it stacks up

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 spin it up?

Difficulty · easy Time to first run · 30min

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

License terms were not stated in the README.

Wtf does this do

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.

Yoink these 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

wtf 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.

View the repo → Decode another repo

This repo across BitVibe Labs

Don't trust strangers blindly. Verify against the repo.