skills.rest
gabi-agent
gabi-agentCOMMUNITY
Explore all skills by this author →
GitHub

sql-toolkit

Automate database design, querying, migrations, and optimization across SQLite, PostgreSQL, and MySQL.

Updated Feb 26, 2026
Search Tags:#indexing#database#migration#backup#sql#query#schema-design
One-click install
npx skills add https://github.com/gabi-agent/openretro --skill sql-toolkit-gabi-agent
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-toolkit
Source: https://github.com/gabi-agent/openretro/tree/main/skills/sql-toolkit
Command: npx skills add https://github.com/gabi-agent/openretro --skill sql-toolkit-gabi-agent

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Centralizes relational database design, querying, migrations, and optimization from the command line, enabling fast work across SQLite, PostgreSQL, and MySQL with schema design, writing queries, creating migrations, indexing, backup/restore, and debugging slow queries.

Core Features & Use Cases

  • Schema design and versioned migrations to evolve databases safely.
  • Complex query authoring, indexing recommendations, and performance debugging.
  • Quick data exploration with SQLite (zero-setup) and production workflows for PostgreSQL/MySQL.

Quick Start

Design a new schema for a SQLite database and generate a corresponding migration.

Frequently Asked Questions about sql-toolkit

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

FAQPage Schema
How do I automate SQL schema design and database migrations from the command line?▼

Automate SQL schema design by defining table structures and generating versioned migrations from the command line. This enables safe database evolution across SQLite, PostgreSQL, and MySQL without manual SQL scripting.

How do I debug slow SQL queries and get indexing recommendations?▼

Debug slow SQL queries by analyzing query execution patterns from the command line. The toolkit identifies performance bottlenecks and provides indexing recommendations to optimize complex queries across PostgreSQL, MySQL, and SQLite.

Can I use this SQL toolkit with both SQLite for local exploration and PostgreSQL for production?▼

Yes, the SQL toolkit supports SQLite for zero-setup local data exploration and PostgreSQL or MySQL for production workflows. It orchestrates querying and optimization across all three database systems directly from the command line.

What's the best way to manage database backup and restore operations for PostgreSQL and MySQL?▼

Manage database backup and restore operations by executing targeted command line instructions. This toolkit automates backup creation and restoration procedures for PostgreSQL and MySQL, ensuring data safety during migrations and schema changes.

Do I need prior experience with SQL patterns to use this database migration and optimization toolkit?▼

Yes, you need familiarity with SQL patterns and direct command line interface usage to operate this database toolkit smoothly. It is designed for users orchestrating complex database design, migrations, and performance tuning tasks.

Why are my complex SQL queries failing after a database migration, and how can I fix them?▼

Complex SQL queries may fail after database migrations due to schema changes or missing indexes. Use the toolkit to review schema versions, apply indexing recommendations, and debug query performance issues directly.

Related Skills

Explore More Software Engineering Skills→
xiaoyuge886xiaoyuge886
196

whodb

Explore schemas, inspect tables, and execute SQL queries across multiple database engines.

Community
Intermediate
Datus-aiDatus-ai
1.5k

report-generator

Generate JSON, CSV, or markdown reports from SQL query results.

Official
Basic
HeldinhowHeldinhow
4

database-migrations

Manage database schema changes through version-controlled migration scripts.

Community
Intermediate
partme-aipartme-ai
610

dbeaver

Guide DBeaver database connections, SQL queries, data management, and administration.

Official
Basic