For ein terminalbasierter Client für SQL-Datenbanken, the strongest matches are xo/usql (usql is a universal command-line SQL interface that lets), dbcli/pgcli (pgcli is a dedicated interactive SQL shell for PostgreSQL) and achristmascarl/rainfrog (Rainfrog is a terminal-based database client that lets you). julianhyde/sqlline and duckdb/duckdb round out the shortlist. Each is ranked by relevance to your query, popularity and recent activity.
Kommandozeilen-Tools für das Abfragen, Verwalten und Interagieren mit relationalen Datenbanken direkt aus dem Terminal.
usql is a universal SQL command-line interface used to connect to and manage multiple SQL and NoSQL databases through a single unified tool. It provides a standardized interface for executing queries across various data stores and serves as a multi-database query tool and schema inspector. The tool distinguishes itself by enabling cross-database data migration, allowing users to pipe result sets from one active database connection directly into another. It also features terminal-based data visualization, which renders query results as graphical charts, graphs, and images directly within the t
usql is a universal command-line SQL interface that lets you interactively or programmatically execute queries across many SQL and NoSQL databases, directly meeting this search for a terminal-based query tool with its built-in interactive shell, auto‑completion, output formatting, and connection‑profile storage.
pgcli is an interactive command-line interface and database management tool for PostgreSQL. It functions as an interactive SQL shell and query editor that allows users to inspect schemas, manage connections, and run queries against PostgreSQL data sources. The tool is distinguished by its real-time, schema-aware autocompletion for keywords, tables, and columns, as well as dynamic SQL syntax highlighting. It provides safety mechanisms through transaction-aware guardrails that warn against or block destructive statements when no active transaction is detected. Broad capabilities include secure
pgcli is a dedicated interactive SQL shell for PostgreSQL with real-time autocompletion and syntax highlighting, making it a command-line database query tool, though its lack of cross-database support means it covers only one database system.
Rainfrog is a terminal-based database client that connects to multiple database engines, combining schema browsing, interactive SQL query execution, and inline data editing into a single terminal interface. It provides a tree navigator for exploring tables, columns, and indexes, and an inline cell editor that automatically constructs and executes the necessary UPDATE statements when a cell value is changed. The application also supports modal Vim-style keyboard shortcuts for cursor movement and editing, making it usable entirely from the keyboard. Query results are fetched in chunks and pagin
Rainfrog is a terminal-based database client that lets you interactively run SQL queries against multiple engines (PostgreSQL, MySQL, SQLite) with a keyboard-driven interface, making it a solid fit for a command-line query tool—though it focuses on interactive use rather than pipe or non-interactive batch execution.
Shell for issuing SQL to relational databases via JDBC
sqlline is a JDBC-based command-line SQL shell that lets you interactively or non-interactively query any relational database from the terminal, with features like auto-completion, output formatting, and connection management — a direct fit for this search.
DuckDB is an in-process analytical database engine designed to run directly within an application process. As a zero-dependency, embedded system, it provides enterprise-grade SQL data processing capabilities without the overhead of managing a dedicated database server. It is built to handle complex analytical and aggregation tasks by storing and retrieving information in columns, allowing for high-performance relational data manipulation. The engine distinguishes itself through a columnar vectorized execution model that maximizes CPU cache efficiency during query operations. It employs adapti
DuckDB's command-line interface lets you run SQL queries interactively or in batch from the terminal, with syntax highlighting and output formatting, but it is limited to its own embedded database engine rather than offering cross‑database connections.
mycli is a MySQL command line client, database administration tool, and SQL query editor. It functions as a terminal interface for executing queries and managing MySQL connections, incorporating an integrated assistant that uses large language models to generate and analyze SQL statements based on the current database schema. The tool provides specialized query authoring capabilities, including context-sensitive syntax suggestions, fuzzy-matching identifier completion for tables and columns, and the ability to handover query buffers to external system text editors. It distinguishes its connec
Mycli is a command-line MySQL client with autocompletion, syntax highlighting, and interactive querying, making it a precise fit for a terminal-based database query tool, though its MySQL-only focus means it does not cover the cross-database support you mentioned.
CLI for SQLite Databases with auto-completion and syntax highlighting
Litecli is a command-line SQLite query tool with auto-completion and syntax highlighting, fitting the need for a terminal-based database client, though it only supports SQLite rather than multiple databases.
A command-line client for SQL Server with auto-completion and syntax highlighting
This is a command-line client for SQL Server with auto-completion and syntax highlighting, ideal for interactive queries from the terminal, but it lacks cross-database support beyond SQL Server.