vi-sql is a terminal user interface for browsing and working with SQL databases.
The software lets you explore schemas, run queries, edit table data, inspect query plans, and connect AI assistants through a built-in Model Context Protocol (MCP) server.
This is free and open source software.
Key Features
- Multi-tab SQL editor with syntax highlighting and autocomplete.
- Query history and integration with your preferred external editor.
- Browse tables, columns, indexes, DDL, and other schema information.
- Filter, sort, add, edit, and delete table rows.
- Copy rows in JSON or CSV format.
- Follow foreign keys and find references between database objects.
- Vim-style navigation and multi-key commands throughout the interface.
- View EXPLAIN and EXPLAIN ANALYZE query plans with cost and timing details.
- Import and export data in CSV, JSON, SQL INSERT, and Markdown formats.
- Built-in MCP server for integration with compatible AI assistants.
- Encrypted connection details with keyring and master-password support.
- Customizable interface themes defined using YAML.
- Supports PostgreSQL, MySQL, and SQLite connections.
Website: github.com/kopecmaciej/vi-sql
Support:
Developer: Maciej Kopeć
License: Apache-2.0
vi-sql is written in Go. Learn Go with our recommended free books and free tutorials.
Related Software
| MySQL Tools | |
|---|---|
| DBeaver | Universal database tool |
| phpMyAdmin | MySQL web administration tool |
| NocoDB | Build databases as spreadsheets |
| MySQL Workbench | Complete visual database design tool |
| mycli | Command line interface for MySQL, MariaDB, and Percona |
| gh-ost | GitHub's Online Schema Migrations for MySQL |
| Beekeeper Studio | Cross-platform SQL editor and database manager |
| usql | Command-line database client |
| sqlit | lazygit of SQL databases |
| Harlequin | Easy, fast, and beautiful database client for the terminal |
| DbGate | Database manager for MySQL, PostgreSQL, MongoDB |
| Percona Toolkit | Essential command-line utilities for MySQL |
| SQuirreL SQL Client | Graphical SQL client written in Java |
| Adminer | Full-featured tool for managing content in MySQL database |
| dblab | Interactive client for PostgreSQL, MySQL, SQLite3, and more |
| Antares | SQL client based on Electron.js and Vue.js |
| XtraBackup | Backup utility for MySQL |
| innotop | Real-time, advanced investigation tool |
| SQLCheck | Detects common SQL anti-patterns |
| Skeema | Manage MySQL and MariaDB schema changes |
| Sequeler | Native Linux SQL client built in Vala and Gtk |
| orchestrator | High availability and replication management tool |
| OmniDB | Collaborative environment For database management |
Read our verdict in the software roundup.
 LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |
Please read our Comment Policy before commenting.