piedpy 2022.1

Powerful Command-line toolkit for MySQL Database.

Forever Scalable

piedpy is a Python based CLI toolkit for MySQL with auto-completion, key binders and syntax highlighting.

Compatibility

piedpy works flawlessly with Linux, OSX, and Windows and requires Python 3.8 or later.

Features

• Auto-completion
• Syntax highlighting
• Smart-completion (enabled by default) will suggest context-sensitive completion.
  • SELECT * FROM <tab> will only show table names.
  • SELECT * FROM users WHERE <tab> will only show column names.
• Support for multiline queries.
• Favorite queries with optional positional parameters. Save a query using \fs alias query and execute it with \f alias whenever you need.
• Timing of sql statements and table rendering.
• Config file is automatically created at ~/.piedpyrc at first launch.
• Log every query and its results to a file (disabled by default).
• Pretty prints tabular data (with colors!)
• Support for SSL connections

Getting Started

Installation

You can install quo via the Python Package Index (PyPI)

pip install -U piedpy

Usage

piedpy --help

Configuration

For more information on using and configuring piedpy, check out our documentation.

Donate🎁

In order to for us to maintain this project and grow our community of contributors. Donate

Getting Help

Community

For discussions about the usage, development, and the future of quo, please join our Google community

• Community👨‍👩‍👦‍👦

Resources

Bug tracker

If you have any suggestions, bug reports, or annoyances please report them to our issue tracker at Bug tracker or send an email to:

📥 [e-mail]

License📑

This software is licensed under the MIT License. See the License file in the top distribution directory for the full license text.

Code of Conduct

Code of Conduct is adapted from the Contributor Covenant, version 1.2.0 available at Code of Conduct