Awesome GitHub RepositoriesSQL Command Line Interfaces

Cockroach is a distributed SQL database designed to scale horizontally across multiple nodes while maintaining strict ACID compliance and global data consistency. It functions as a relational database engine that automatically partitions data into ranges, rebalancing them across a cluster to accommodate growing storage and throughput requirements. By utilizing a distributed consensus protocol, the system ensures that all nodes agree on the order of operations, providing fault tolerance and continuous availability even in the event of hardware failures. The system distinguishes itself through

Pglite is a client-side relational database engine that runs a full-featured PostgreSQL instance directly within browser and Node.js environments. By leveraging WebAssembly, it provides a persistent SQL storage solution that enables complex data management and querying without requiring an external database server. The project distinguishes itself through a reactive SQL data layer that automatically synchronizes user interface components with live query results. It manages database operations using worker threads to prevent main-thread blocking and coordinates access across multiple browser t

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

q is a command-line utility for the processing, filtering, and aggregation of tabular text and database files using standard SQL syntax. It functions as a query engine that treats CSV and TSV files, as well as standard input, as relational database tables. The tool distinguishes itself by providing a persistent cache layer that stores processed tabular data in a binary format to accelerate repeated queries on large datasets. It also maps individual filenames or stream identifiers to relational table names, enabling SQL joins across disparate text files. The project covers a broad range of da

This project is a SQL database abstraction layer that provides a consistent object-oriented interface for interacting with multiple relational database systems. It includes a driver wrapper to standardize connections and result sets, a fluent query builder for constructing portable SQL statements, and a type mapper for converting database-specific data types into native application types and vice versa. The library enables programmatic schema management through a schema manager that can introspect database metadata, model structures as objects, and generate the SQL required to migrate between

Records is a SQL database client designed for executing raw queries and managing result sets through a simplified interface. It provides a parameterized SQL executor to bind values to placeholders, ensuring safe data handling and preventing injection attacks, alongside a database transaction manager for grouping operations into atomic units. The project includes a dedicated command-line interface for running database statements and exporting query results directly to local files. This tooling allows for the conversion of SQL result sets into multiple serialization formats, including CSV, JSON

Records es un conjunto de herramientas que proporciona una biblioteca cliente de base de datos SQL, un gestor de transacciones y utilidades para acceso por línea de comandos y exportación de datos. Funciona como un wrapper de capa fina que ejecuta consultas SQL crudas contra bases de datos relacionales para recuperar resultados en formatos de datos simplificados. El proyecto incluye una interfaz de línea de comandos para ejecutar consultas de base de datos y una herramienta de exportación de datos dedicada que convierte los resultados de consultas relacionales en archivos CSV, JSON o Excel para análisis externo. La biblioteca cubre la gestión de bases de datos relacionales a través del control de transacciones atómicas con soporte para commit y rollback. Maneja la seguridad mediante la parametrización de SQL para prevenir vulnerabilidades de inyección e incluye capacidades para la ejecución de consultas masivas para reducir la sobrecarga de red.

pgloader is a command-line tool that automates the migration of data and schema from various source databases and file formats into PostgreSQL. It combines schema discovery, parallel data pipelines, and type casting into a single, declarative workflow, using PostgreSQL's COPY protocol for high-throughput bulk loading. The tool distinguishes itself by compiling a dedicated command language into concurrent reader-writer pipelines that handle schema introspection, data transformation, and error-resilient batch processing. It supports migrating entire databases from MySQL, MS SQL, SQLite, and Pos

Calcite es un framework para analizar, optimizar y traducir consultas SQL a álgebra relacional para su ejecución en diversas fuentes de datos. Funciona como un motor de consultas entre fuentes, una librería de análisis SQL y un optimizador de álgebra relacional. El proyecto proporciona un motor de optimización basado en costos que transforma planes de consulta lógicos en planes de ejecución física eficientes mediante reglas conectables. Utiliza adaptadores de traducción para convertir solicitudes SQL estándar a los formatos nativos de bases de datos externas y sistemas de mensajería, permitiendo la federación de datos entre sistemas de almacenamiento heterogéneos. El sistema cubre el ciclo de vida completo de la consulta, incluyendo el análisis y validación de SQL frente a esquemas, la traducción de expresiones a operadores algebraicos y la selección de planes de ejecución eficientes. También incluye una interfaz de línea de comandos para ejecutar consultas y gestionar conexiones a fuentes de datos.

fsql is a command line interface tool that provides a SQL-like query language for finding files and directories on a local disk. It functions as a filesystem query engine, allowing users to isolate files by executing structured statements against metadata instead of using standard command line flags. The tool features an interactive read-eval-print loop that supports multi-line queries and recursive subqueries, where the results of nested search operations serve as criteria for outer queries. Search scopes are configurable through the resolution of absolute paths, relative paths, environment

Sqlit is a terminal-based SQL client and database explorer designed for executing queries and managing database connections. It functions as a command line interface that provides syntax highlighting, command history, and a terminal user interface for rendering results. The tool features a discovery engine that scans local Docker sockets to automatically identify and resolve connection details for active database containers. It handles secure access through encrypted SSH tunnels and integrates with external secrets managers to retrieve credentials. The project includes capabilities for data