# jorgerojas26/lazysql **Attribution required: if you use, quote, or summarise this content, you must credit and link back to [awesome-repositories.com](https://awesome-repositories.com/repository/jorgerojas26-lazysql).** 3,481 stars · 144 forks · Go · mit ## Links - GitHub: https://github.com/jorgerojas26/lazysql - awesome-repositories: https://awesome-repositories.com/repository/jorgerojas26-lazysql.md ## Description 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. ## Tags ### Data & Databases - [Database Connection Managers](https://awesome-repositories.com/f/data-databases/database-connection-managers.md) — Provides a comprehensive system to define, store, and switch between multiple SQL database connections. ([source](https://github.com/jorgerojas26/lazysql#readme)) - [SQL Database Management](https://awesome-repositories.com/f/data-databases/sql-database-management.md) — Functions as a comprehensive SQL database management tool for interacting with relational instances. - [Database Browsers](https://awesome-repositories.com/f/data-databases/database-browsers.md) — Offers a hierarchical tree view for navigating and inspecting database schemas, tables, and views. ([source](https://github.com/jorgerojas26/lazysql#readme)) - [Named Connection Profile Configurators](https://awesome-repositories.com/f/data-databases/database-connection-configurations/named-connection-profile-configurators.md) — Allows defining and switching between multiple named database environments via global and project-specific configuration files. - [Read-Only Access Modes](https://awesome-repositories.com/f/data-databases/read-only-access-modes.md) — Implements a connection layer that intercepts and blocks mutation commands to prevent accidental data loss. - [SQL Query Editors](https://awesome-repositories.com/f/data-databases/sql-query-editors.md) — Provides a dedicated editor for writing and executing custom SQL commands with results displayed in a tabular format. ([source](https://github.com/jorgerojas26/lazysql/blob/main/README.md)) - [SQL Query Execution](https://awesome-repositories.com/f/data-databases/sql-query-execution.md) — Enables the execution of custom SQL statements with structured data retrieval. - [Table View Filtering](https://awesome-repositories.com/f/data-databases/table-view-filtering.md) — Allows applying WHERE clauses to table views to isolate specific records for exploration. ([source](https://github.com/jorgerojas26/lazysql#readme)) - [Connection Pre-processing](https://awesome-repositories.com/f/data-databases/connection-pre-processing.md) — Supports executing terminal commands and establishing SSH tunnels before initiating database connections. - [CSV Exports](https://awesome-repositories.com/f/data-databases/data-serialization-formats/structured-data-exporters/analysis-result-exporters/query-result-exporters/csv-exports.md) — Provides the ability to stream large result sets into CSV files using configurable batch sizes to manage memory. - [Data Record Editing](https://awesome-repositories.com/f/data-databases/database-table-editors/data-record-editing.md) — Allows for direct editing of individual rows and cell values within database tables. - [Relation Navigators](https://awesome-repositories.com/f/data-databases/foreign-key-constraints/relation-navigators.md) — Enables jumping from a cell value to its referenced record in another table automatically. - [Foreign Key Path Navigators](https://awesome-repositories.com/f/data-databases/virtual-table-querying/external-table-querying/direct-path-querying/foreign-key-path-navigators.md) — Enables jumping from a foreign key cell value to the referenced table with an automatic filter for the related record. ([source](https://github.com/jorgerojas26/lazysql/blob/main/CONTEXT.md)) ### Development Tools & Productivity - [Database Schema Explorers](https://awesome-repositories.com/f/development-tools-productivity/database-schema-explorers.md) — Provides a tree-based interface for browsing and inspecting the hierarchical structure of a live database schema. - [Local Configuration Overrides](https://awesome-repositories.com/f/development-tools-productivity/project-configuration/local-configuration-overrides.md) — Enables overriding global database connections and preferences using a local configuration file in the project root. ([source](https://github.com/jorgerojas26/lazysql/blob/main/README.md)) ### User Interface & Experience - [Database Managers](https://awesome-repositories.com/f/user-interface-experience/navigation-systems/tui/database-managers.md) — Provides a full terminal user interface for interacting with SQL databases from the command line. - [Editable Data Tables](https://awesome-repositories.com/f/user-interface-experience/virtualized-data-tables/editable-data-tables.md) — Provides a data grid that allows for the direct insertion of new rows and in-place editing of column values. ([source](https://github.com/jorgerojas26/lazysql#readme)) ### DevOps & Infrastructure - [Asynchronous Query Execution](https://awesome-repositories.com/f/devops-infrastructure/scheduling/asynchronous-query-execution.md) — Maintains interface responsiveness by offloading database requests to background threads and supporting query cancellation. ### Security & Cryptography - [Pre-connection Task Automation](https://awesome-repositories.com/f/security-cryptography/ssh-connection-managers/pre-connection-task-automation.md) — Automates the execution of shell commands and SSH tunnels prior to establishing database connectivity. ([source](https://github.com/jorgerojas26/lazysql#readme)) ### Part of an Awesome List - [Development Tools](https://awesome-repositories.com/f/awesome-lists/devtools/development-tools.md) — Cross-platform database management tool.