15+ database CLI tools for queries, migrations, and checks

Need to query a database or run a migration without leaving the terminal? This list has clients with autocomplete such as pgcli, mycli, and litecli, engines you can run from a prompt such as DuckDB and SQLite, and migration tools such as dbmate, Atlas, and Goose. Use the filters to narrow the list by app type, platform, language, or license.

showing 1–18 of 18 apps

appcategorystarspricinglicenseplatformslast commit
The command-line client for etcd, the distributed key-value store. databases +152.6KfreeApache-2.0linux, macos, windowsNov 12, 2026
An in-process analytical database with a CLI for querying local files, Parquet, JSON, and CSV. databases +143.1KfreeMITlinux, macos, windowsNov 13, 2026
Generates type-safe application code from SQL queries and database schemas. databases +118.5KfreeMITlinux, macos, windowsOct 23, 2026
A PostgreSQL client with auto-completion, syntax highlighting, multiline editing, and saved queries. databases +113.4KfreeBSD-3-Clauselinux, macos, windowsNov 4, 2026
A MySQL and MariaDB client with auto-completion, syntax highlighting, and readable table output. databases +112KfreeBSD-3-Clauselinux, macos, windowsNov 14, 2026
Applies database migrations written in SQL or Go and tracks their versions in the database. databases +111.7KfreeMITlinux, macos, windowsNov 12, 2026
Publishes SQLite databases as a searchable web interface and JSON API from one command. databases +111.6KfreeApache-2.0linux, macos, windowsNov 15, 2026
A self-contained SQL database with a command shell for queries, imports, backups, and inspection. databases +111KfreePublic domainlinux, macos, windowsNov 15, 2026
A universal SQL client with psql-style commands and drivers for many database engines. databases +110.2KfreeMITlinux, macos, windowsNov 15, 2026
Lints and formats SQL across many dialects with configurable rules and templating support. databases +110KfreeMITlinux, macos, windowsNov 15, 2026
Inspects database schemas and plans, verifies, and applies versioned or declarative migrations. databases +18,822freemiumApache-2.0linux, macos, windowsNov 5, 2026
Runs plain SQL migrations against PostgreSQL, MySQL, SQLite, ClickHouse, and other databases. databases +17,546freeMITlinux, macos, windowsNov 9, 2026
slowA SQLite client with auto-completion, syntax highlighting, table formatting, and configuration profiles. databases +13,320freeBSD-3-Clauselinux, macos, windowsJun 7, 2026
A top-like PostgreSQL activity viewer for sessions, queries, locks, and server statistics. databases +13,057freePostgreSQLlinux, macosNov 5, 2026
An interactive Redis client with completion, highlighting, paging, and command documentation. databases +12,764freeBSD-3-Clauselinux, macos, windowsNov 2, 2026
Runs local Supabase services and manages migrations, functions, types, projects, and deployments. devops and cloud +12,467freemiumMITlinux, macos, windowsNov 13, 2026
Creates, transforms, queries, and exports SQLite databases from JSON, CSV, or TSV data. databases +12,197freeApache-2.0linux, macos, windowsOct 11, 2026
The official JavaScript shell for querying, scripting, and administering MongoDB deployments. databases403freeApache-2.0linux, macos, windowsNov 15, 2026

How do you choose a database CLI?

Start with the database you use. Most clients only speak one, such as Postgres, MySQL, or SQLite.

  • Client or engine. Some tools connect to a database server. Others are the database itself, running on local files.
  • Migrations. Check whether a migration tool uses plain SQL files or its own format, and whether it supports your database.
  • Language. Python tools usually install with pip, while Go and Rust tools often ship as a single binary. The Language filter helps if you'd rather not install a runtime.
  • Platform. Check the Platform filter for your system.

What should you keep in mind?

Connection strings often include passwords. Keep them in a password file or an environment variable, not in your shell history. Run new migrations against a copy of the database before you run them on the real one.