query-cli

id	name	email
1	Alice	alice@example.com
2	Bob	bob@example.com
… 18 more rows

name

Alice

alice@example.com

Bob

bob@example.com

… 18 more rows

🖥️

Keyboard-driven TUI

Built with OpenTUI and React. Navigate, edit, and run queries entirely from the keyboard.

🗄️

Multi-database Support

Connect to PostgreSQL, SQLite, and MySQL from a single interface.

🤖

AI Assistant

Generate and explain SQL using Anthropic, OpenAI, OpenRouter, or Google Gemini.

📋

Query Editor

Tabbed queries with save/rename, syntax highlighting, and clipboard copy.

🔍

Schema Explorer

Browse tables, columns, and indexes side-by-side without leaving the terminal.

⌨️

Slash Commands

Quick actions like /export, /clear, /quit, and more right inside the editor.

See it in action

Connection Manager

Select, create, and manage your database connections from a clean terminal interface.

query-cli — Connection Select

query-cli

Select a connection

↑/↓navigate·enterconfirm·ctrl+cquit

Production DB

postgres://admin@db.example.com:5432/app

Local Dev

postgres://postgres@localhost:5432/myapp

+ New connection

Create a new database connection

Quit

Exit query-cli

query-cli — Connection Form

New PostgreSQL connection

Name:My postgres db▌

Host:localhost

Port:5432

Database:postgres

User:postgres

Password:

tabmove·enternext / connect·escback

Main Interface

The main screen splits into a schema explorer, query editor, and result panel — all inside your terminal.

query-cli — Main Screen

·docme(postgres)

▶ Run (F5/Ctrl+R)·Ctrl+Ssave·(F9/Ctrl+P)commands·ctrl+cquit

Explorer

DatabaseQueries

▶Search table name...

▶drizzle.__drizzle_migrations

▶pgboss.bam

▶pgboss.job

▶pgboss.job_common

▶pgboss.queue

▶pgboss.schedule

▶pgboss.subscription

New query

SELECT * FROM users WHERE active = true▌

▶FROM

▶WHERE

Result

No results yet.F5 / ctrl+r runs the statement.

Command Palette & Help

Access every feature through the searchable command palette. Never forget a shortcut — press F1 or Ctrl+H anytime.

query-cli — Command Palette

query-cli — Help

AI Configuration

Configure AI providers directly in the app — no manual file editing needed.

query-cli — AI Assistant

query-cli·myapp(postgres)

▶ Run

New query

@ai: list all active users of this month▌

Result

SELECT * FROM users

WHERE active = true

AND created_at >= DATE_TRUNC('month', NOW())

>_ query_cliTerminal Database Client

Keyboard-driven TUI

Multi-database Support

AI Assistant

Query Editor

Schema Explorer

Slash Commands

See it in action ​

Connection Manager ​

Main Interface ​

Command Palette & Help ​

AI Configuration ​

See it in action

Connection Manager

Main Interface

Command Palette & Help

AI Configuration