Mycli

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 connectivity through SSH tunneling to remote servers and the use of system-native keyrings for encrypted credential management.

Broad capabilities include batch query execution with session persistence, database activity logging for auditing, and the redirection of result sets via shell-style operators. The interface supports formatted tabular output, custom prompt styling, and the management of favorite queries with positional parameters.

Features

MySQL Administration Tools - Functions as a comprehensive command line tool for managing MySQL databases and executing administrative tasks.

SQL Command Line Interfaces - Provides a terminal-based interface for executing SQL statements and formatting query output.

AI Query Generators - Uses large language models to automate the generation and analysis of complex MySQL queries using schema context.

Natural Language Query Generators - Provides an integrated assistant that translates natural language prompts into structured SQL queries based on the current database schema.

Database Administration Tools - Provides a secure terminal workspace for managing MySQL connections, executing batch scripts, and logging activity.

LLM-Based SQL Generation - Integrates LLMs to convert natural language prompts into executable SQL scripts based on the active database schema.

Database Identifier Autocompletion - Provides real-time, case-insensitive fuzzy suggestions for database table and column names.

MySQL Command Line Interfaces - Provides a feature-rich terminal interface for executing MySQL queries with intelligent autocomplete and syntax highlighting.

Context-Aware Autocompletion Providers - Suggests SQL keywords and identifiers dynamically based on the current statement's context.

SQL Development Environments - Provides an integrated environment for iteratively writing and refining SQL queries with autocomplete and editor integration.

Keyring-Integrated Connection Security - Encrypts sessions via SSL and retrieves stored passwords from the system native keyring.

SSH Tunneling - Establishes secure database connections by tunneling traffic through an encrypted SSH jump host.

LLM Contextual Integrations - Enriches LLM API payloads with the current database schema to generate and analyze context-aware SQL queries.

SQL Formatting - Adjusts indentation and line breaks in SQL statements to improve human readability.

Tabular Result Rendering - Renders tabular data with color-coding and calculates statement execution time for better readability.

Execution State Persistence - Tracks script execution checkpoints and connection metadata to resume database operations after interruptions.

Metadata-Based Identifier Matching - Implements case-insensitive fuzzy matching for table and column names to provide intelligent identifier completion.

SQL Script Execution - Executes SQL scripts from files with support for checkpoints to resume interrupted operations.

Real-Time SQL Completion - Offers real-time, context-sensitive syntax suggestions for SQL keywords and identifiers to accelerate query writing.

Connection and Session Management - Manages the lifecycle of database connections and automatically restores sessions if the connection is lost.

Credential Managers - Retrieves encrypted database credentials from the system's native secret store to avoid plain text password files.

Database Operation Auditing - Records executed SQL statements and their results to files for auditing and debugging purposes.

External Editor Integration - Allows users to spawn a system text editor for modifying complex multiline queries before execution.

Database and Storage Tools - Interactive MySQL client with auto-completion and syntax highlighting.

Database Clients - MySQL client with autocompletion.

Database Management Systems - Terminal interface for MySQL with syntax highlighting and completion.

Advanced CLI Tools - MySQL CLI with auto-completion and syntax highlighting.

CLI Tools - Listed in the “CLI Tools” section of the Awesome Python awesome list.

Command Line Interfaces - MySQL CLI with autocompletion and syntax highlighting.

Command Line Tools - Listed in the “Command Line Tools” section of the The Book Of Secret Knowledge awesome list.

GUI Clients - Provides a terminal client with autocompletion and syntax highlighting.

CLI Tools - MySQL CLI with autocompletion.

dbclimycli

Features

Star history