SQL Client

A modern, native PostgreSQL client built with Electron, Svelte, and CodeMirror.

Note: Currently tested with PostgreSQL only, on macOS. Other databases and platforms may work but are not officially supported yet.

Features

• Query Editor — CodeMirror-powered SQL editor with PostgreSQL autocomplete, syntax highlighting, and formatting (Cmd+Shift+F)
• Inline Editing — Edit query results directly in the data grid. Supports all types including a dedicated JSON/JSONB modal editor
• Connection Manager — Save and organize multiple connections with color-coded indicators. Quick-switch with Cmd+K
• Multi-Tab Interface — Work on multiple queries and table previews simultaneously
• Schema Browser — Browse tables, columns, indexes, and foreign keys grouped by schema
• AI Assistant — Built-in Claude integration for explaining queries, fixing errors, and generating SQL from natural language
• Query History — Searchable execution history with filtering by type (manual, transaction, error)
• Saved Queries — File-backed .sql queries with auto-save, stored in a configurable directory
• Undo Support — Rollback INSERT, UPDATE, and DELETE operations directly from the app

Tech Stack

• Electron — Cross-platform desktop app
• Svelte 5 — Reactive UI components
• CodeMirror 6 — Code editor with SQL and JSON language support
• Tailwind CSS 4 — Styling
• Postgres.js — PostgreSQL driver
• Anthropic SDK — AI assistant integration

Getting Started

Prerequisites

• Bun (or Node.js 20+)
• A running PostgreSQL instance

Install

git clone https://github.com/lyubo-velikov/sql-client.git
cd sql-client
bun install

Development

bun run dev

Build

bun run build

Keyboard Shortcuts

License

MIT