Lazysql

LazySQL is a terminal user interface database manager and SQL client. It functions as a query runner and connection manager for interacting with SQL databases from the command line.

The project features a read-only connection mode that blocks mutation commands to prevent accidental data loss. It supports automated pre-connection tasks, including the execution of shell commands and the establishment of SSH tunnels, and allows for both global and project-specific configuration.

The interface provides a tree-based schema browser for navigating tables, a dedicated SQL query editor with tabular results, and tools for direct table data manipulation. It includes a JSON data viewer, foreign key relationship navigation for jumping between related records, and batch-based CSV export for large datasets.

The application utilizes asynchronous query management to maintain interface responsiveness and supports custom keybindings and external editor integration.

Features

Database Connection Managers - Provides a comprehensive system to define, store, and switch between multiple SQL database connections.

SQL Database Management - Functions as a comprehensive SQL database management tool for interacting with relational instances.

Database Browsers - Offers a hierarchical tree view for navigating and inspecting database schemas, tables, and views.

Named Connection Profile Configurators - Allows defining and switching between multiple named database environments via global and project-specific configuration files.

Read-Only Access Modes - Implements a connection layer that intercepts and blocks mutation commands to prevent accidental data loss.

SQL Query Editors - Provides a dedicated editor for writing and executing custom SQL commands with results displayed in a tabular format.

SQL Query Execution - Enables the execution of custom SQL statements with structured data retrieval.

Table View Filtering - Allows applying WHERE clauses to table views to isolate specific records for exploration.

Database Schema Explorers - Provides a tree-based interface for browsing and inspecting the hierarchical structure of a live database schema.

Local Configuration Overrides - Enables overriding global database connections and preferences using a local configuration file in the project root.

Database Managers - Provides a full terminal user interface for interacting with SQL databases from the command line.

Editable Data Tables - Provides a data grid that allows for the direct insertion of new rows and in-place editing of column values.

Connection Pre-processing - Supports executing terminal commands and establishing SSH tunnels before initiating database connections.

CSV Exports - Provides the ability to stream large result sets into CSV files using configurable batch sizes to manage memory.

Data Record Editing - Allows for direct editing of individual rows and cell values within database tables.

Relation Navigators - Enables jumping from a cell value to its referenced record in another table automatically.

Foreign Key Path Navigators - Enables jumping from a foreign key cell value to the referenced table with an automatic filter for the related record.

Asynchronous Query Execution - Maintains interface responsiveness by offloading database requests to background threads and supporting query cancellation.

Pre-connection Task Automation - Automates the execution of shell commands and SSH tunnels prior to establishing database connectivity.

Development Tools - Cross-platform database management tool.

jorgerojas26lazysql

Features

Star history