Open CLI

mycli

database
$ pipx install mycli
Summary

MySQL shell, autocomplete, and readable results from the terminal.

  • mycli fits data & db well, especially for mysql shell, autocomplete, and readable results from the terminal.
  • 3,885 homebrew installs (30d).
  • Verify with `mycli --version` first.
  • Best treated as a human-first terminal tool.
  • Output is mostly text-first, so verify results before scripting around it.
database-mycli-SKILL.md

Mycli guide

MySQL shell, autocomplete, and readable results from the terminal. Built by dbcli.

Open CLI packages the install path, verify step, and safe-start workflow so this tool can move from “interesting CLI” to something you can actually use. It also integrates with skills.sh so each CLI comes with the right companion skills, not just a binary and a docs link.

When to apply

  • mysql shell, autocomplete, and readable results from the terminal.
  • You work with databases and want a fast terminal interface.
  • You need mysql shell.
  • You need autocomplete.
  • You need readable results.

Quick reference

Installpipx install mycli
Verifymycli --version
First real commandmycli mysql://root@localhost

Open CLI × skills.sh

Open CLI integrates mycli with the right skills.sh companions so you get the tool and the workflow together.

Database Schema Design

Recommended pairing

Open CLI recommends this skills.sh skill because it fits database workflows. Use better schema and migration decisions when a CLI touches databases.

View on skills.sh
$ npx skills add https://github.com/supercent-io/skills-template --skill database-schema-design
Starter prompt

Use mycli together with the Database Schema Design skills.sh skill. Inspect the current schema or data first, summarize what matters, and ask before any migration or write action.

Also useful from skills.sh
Data Analysisskills.shBackend Testingskills.sh

Why this tool

  • mycli fits data & db well, especially for mysql shell, autocomplete, and readable results from the terminal.
  • 3,885 homebrew installs (30d).
  • Verify with `mycli --version` first.

Watch-outs

  • Automation can be brittle.
  • Output is mostly plain text.
  • Start with read-only or dry-run commands.

Example workflow

1. mycli mysql://root@localhost

Safe start

Step 1

Install mycli.

Step 2

Run `mycli --version` first.

Step 3

Start with `mycli mysql://root@localhost`.

Step 4

Install a CLI that matches your database engine.

Alternatives worth considering

prisma

Schema design, migrations, and type-safe db workflows from the terminal.

drizzle-kit

Migrations, schema diffs, and typescript db tooling from the terminal.

pgcli

Postgres shell, autocomplete, and readable results from the terminal.