Build Status Coverage Status License: MIT PyPI version

About

MitzaSQL is a free Python3 TUI MySQL client for Linux which aims to provide an easy-to-use console alternative to GUI clients. It is not meant to be a full-fledged GUI client, it only provides a read-only view of the database, though you can manipulate the data by using raw SQL queries. Some of the main features are:

  • Manage multiple sessions
  • View databases
  • View list of tables, sql views & stored procedures in a database
  • View rows in a table or sql view:
  • Easily sort table data
  • Filter table data using VIM-like commands (:like, :gt, :lt, :in…)
  • SQL Query editor with syntax highlighting, smart autocomplete and clipboard support (optional dependency needs to be installed)
  • VIM style keyboard shortcuts
  • VIM style commands with autocomplete support
  • Macros support

MitzaSQL is heavily inspired by HeidiSQL and its licensed under MIT. The lexer’s tokens implementation used by the auto complete system was taken from the python-sqlparse project.

Demo and screenshots are available here.

Project goals

  • Minimal dependencies
  • Ease of use
  • No mouse support

Serving suggestion

Best served with tmux and vim.

Windows & MacOS ports

To run MitzaSQL on Windows/MacOS build a Docker image and run it inside a container. Use the project’s Dockerfile as a starting point. An official Docker image is coming soon.

Planned features

  • Support SSL connections
  • Official Docker image

Known issues

See the github project page, section Performance and known issues.

Security

See the github project page, section Security.

Bugs

Please report any bugs here: https://github.com/vladbalmos/mitzasql/issues.

Author

Vlad Balmos