skills.rest
MomoDaviluke
MomoDavilukeCOMMUNITY
Explore all skills by this author →
GitHub

sql-toolkit

Automate relational database design, migrations, and optimization for SQLite, PostgreSQL, and MySQL.

2|Updated Mar 3, 2026
Search Tags:#performance#indexing#database#migrations#cli#sql
One-click install
npx skills add https://github.com/MomoDaviluke/star-citizen-promotion --skill sql-toolkit-momodaviluke
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-toolkit
Source: https://github.com/MomoDaviluke/star-citizen-promotion/tree/main/.agents/skills/sql-toolkit
Command: npx skills add https://github.com/MomoDaviluke/star-citizen-promotion --skill sql-toolkit-momodaviluke

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automates relational database design, migrations, indexing, backups, and query tuning from the command line for SQLite, PostgreSQL, and MySQL.

Core Features & Use Cases

  • Schema design and migrations across SQLite, PostgreSQL, and MySQL
  • Direct SQL querying, indexing strategies, and performance debugging
  • Backup/restore workflows and data exploration from the CLI

Quick Start

Initialize a SQLite project and generate a migration to create core tables for your app.

Frequently Asked Questions about sql-toolkit

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

FAQPage Schema
How do I automate database migrations for SQLite, PostgreSQL, and MySQL from the command line?▼

You can automate database migrations across SQLite, PostgreSQL, and MySQL by running CLI commands that generate schema changes without requiring ORMs. The toolkit directly applies SQL migration scripts to update your relational database schema.

What's the best way to debug slow SQL queries and optimize indexing strategies without an ORM?▼

Debug slow SQL queries by running direct SQL performance tuning commands from the CLI. The toolkit analyzes your queries across database engines and helps optimize indexing strategies to improve relational database performance.

Can I generate database schemas and handle backups directly from the CLI?▼

Yes, you can design relational database schemas and execute backup or restore workflows entirely from the CLI. The toolkit manages schema creation and data exploration for SQLite, PostgreSQL, and MySQL without needing external graphical tools.

Does this SQL toolkit require an ORM to manage cross-engine database compatibility?▼

No, this SQL toolkit requires direct SQL usage without ORMs to ensure cross-engine compatibility. It manages schema creation, migrations, and indexing natively across SQLite, PostgreSQL, and MySQL from the command line.

Why do I need direct SQL knowledge to use this CLI toolkit for database optimization?▼

You need direct SQL knowledge because the toolkit operates without ORMs to maintain cross-engine compatibility. This approach allows precise schema design, indexing, and query tuning directly on SQLite, PostgreSQL, and MySQL databases.

Related Skills

Explore More Software Engineering Skills→
BAIZ1DBAIZ1D

base

Automate LibreOffice Base database creation, management, and data operations.

Community
Intermediate
dige04dige04

databases

Analyze and optimize MongoDB and PostgreSQL performance across production workloads.

Community
Intermediate
greencmgreencm
1

land-and-deploy

Merge pull requests, run CI tests, and deploy to production with canary checks.

Community
Advanced
isharoverwhiteisharoverwhite
13

sqlalchemy-orm

Implement SQLAlchemy 2.0 ORM models for Python database operations.

Community
Intermediate