database

Run SQL queries and database administration across SQLite, PostgreSQL, and MySQL via CLI.

55|4|Updated Feb 5, 2026
One-click install
npx skills add https://github.com/bug-ops/zeph --skill database-bug-ops
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/bug-ops/zeph/tree/main/.zeph/skills/database
Command: npx skills add https://github.com/bug-ops/zeph --skill database-bug-ops

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps developers and database administrators streamline running SQL queries and managing database schemas across SQLite, PostgreSQL, and MySQL from a single CLI, reducing tool-switching and context switching.

Core Features & Use Cases

  • Cross-engine SQL execution and scripting: work with sqlite3, psql, and mysql from a unified interface.
  • Schema inspection and modification: list tables, describe schemas, create or alter tables, and apply migrations.
  • Data import/export and backups: export data to CSV or JSON, import data, and back up or restore databases with SQL dumps.
  • Performance analysis: run EXPLAIN plans and review query performance across engines.

Quick Start

Run a sample query against a local database to verify the setup and retrieve results.

Frequently Asked Questions about database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run SQL queries across SQLite, PostgreSQL, and MySQL from the command line?

Run SQL queries across SQLite, PostgreSQL, and MySQL from the command line using a unified interface that supports the sqlite3, psql, and mysql CLI tools for cross-engine execution and scripting.

What is the best way to inspect and modify database schemas from the CLI?

Inspect and modify database schemas from the CLI using commands to list tables, describe schemas, create or alter tables, and apply migrations across SQLite, PostgreSQL, and MySQL.

Can I export data to CSV and back up databases using command line tools?

Export data to CSV or JSON, import data, and back up or restore databases with SQL dumps directly from the command line across SQLite, PostgreSQL, and MySQL.

How do I analyze query performance with EXPLAIN plans in PostgreSQL or MySQL?

Analyze query performance in PostgreSQL or MySQL by running EXPLAIN plans and reviewing execution details from the command line to identify bottlenecks across different database engines.

Does this database CLI tool require separate clients for SQLite, PostgreSQL, and MySQL?

The database CLI tool relies on the sqlite3, psql, and mysql client tools to function, providing a unified interface that reduces tool-switching when managing multiple database engines.