Maxteabag/sqlit
Sqlit
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 management, such as streaming query results into CSV or JSON files. It also provides in-memory result filtering and fuzzy searching to explore large datasets without re-executing SQL statements.
Features
- SQL Query Interfaces - Provides a dedicated terminal interface for executing raw SQL commands against connected databases.
- Database Connection Managers - Manages database connections using connection strings, URLs, and saved profiles for streamlined data access.
- SQL Database Management - Combines container discovery and result set browsing to explore relational databases from the terminal.
- Terminal User Interfaces - Implements a terminal user interface for rendering SQL query results and maintaining command history.
- SQL Command Line Interfaces - Offers a terminal-based CLI for executing SQL statements with syntax highlighting and command history.
- SQL-to-CSV Exporters - Exports SQL query results directly into portable CSV or JSON files.
- Query Result Exporters - Supports saving the results of SQL queries into machine-readable formats such as CSV or JSON.
- Row-Based Stream Writing - Uses row-based stream writing to export large database result sets to CSV or JSON without overloading system memory.
- In-Page Search Filters - Provides fast fuzzy searching and filtering of query results directly within the terminal interface without re-executing SQL.
- SQL Data Export Utilities - Provides a command line interface specifically for executing queries and streaming output to CSV or JSON files.
- Container Image Discovery - Automatically identifies active database containers by scanning the local Docker socket to simplify connection setup.
- Container Runtime Discovery - Automatically detects active database containers to resolve connection details without manual configuration.
- SSH Tunneling - Establishes encrypted SSH tunnels to route database traffic securely through intermediate servers.
- Secure Database Access - Secures database connectivity using encrypted SSH tunnels and external secrets managers.
- Secrets and Credential Management - Integrates with external secrets managers and SSH tunnels to securely retrieve and protect database authentication credentials.
- Secret Vault Integrations - Retrieves sensitive database credentials from external secure vaults to avoid storing secrets in local configuration files.
- Large Dataset Explorers - Allows interactive inspection of large query result sets using fuzzy search and in-memory filters.
- Entwicklungstools - Lightweight TUI for SQL databases.
