skills.rest
albertdobmeyer
albertdobmeyerCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

sql-toolkit

Manage SQL database tasks across SQLite, PostgreSQL, and MySQL.

2|1|Updated Mar 2, 2026
Search Tags:#indexing#postgresql#migrations#sqlite#backup#sql#mysql
One-click install
npx skills add https://github.com/albertdobmeyer/opentrapp --skill sql-toolkit-albertdobmeyer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-toolkit
Source: https://github.com/albertdobmeyer/opentrapp/tree/main/workloads/skills/skills/sql-toolkit
Command: npx skills add https://github.com/albertdobmeyer/opentrapp --skill sql-toolkit-albertdobmeyer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill removes the friction of working directly with relational databases by giving you a practical, command-line-friendly guide for querying, designing, migrating, backing up, and tuning SQL systems.

Core Features & Use Cases

  • Database Querying: Write joins, aggregations, window functions, CTEs, and JSON queries for real-world data analysis.
  • Schema and Migration Workflows: Create tables, add constraints, manage indexes, and apply repeatable migration scripts.
  • Performance and Operations: Use EXPLAIN, analyze indexes, and handle backup and restore tasks across SQLite, PostgreSQL, and MySQL.
  • Use Case: A developer can use this Skill to inspect a slow report query, identify the missing index, update the schema safely, and verify the result with execution plans.

Quick Start

Ask the skill to help with your SQL task by describing the database engine, the goal, and any table or query details you already have.

Frequently Asked Questions about sql-toolkit

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

FAQPage Schema
How do I write complex SQL queries with window functions and CTEs?▼

SQL queries using window functions, CTEs, and complex joins can be written by providing your database engine and table details to get direct command-line SQL examples for real-world data analysis.

What is the best way to manage SQL database schema migrations from the CLI?▼

SQL database schema migrations are managed by creating tables, adding constraints, and applying repeatable migration scripts directly from the command line across SQLite, PostgreSQL, and MySQL.

How do I use EXPLAIN to analyze and tune slow PostgreSQL query performance?▼

PostgreSQL query performance tuning uses EXPLAIN analysis to inspect slow report queries, identify missing indexes, and verify execution plans after safely updating the schema.

Can I handle SQLite backup and restore operations without using an ORM?▼

SQLite backup and restore operations are supported directly via command-line patterns, providing relational database management without requiring ORM-based abstractions.

Does this SQL approach work for querying JSON data in MySQL?▼

MySQL JSON queries are supported alongside standard aggregations and joins, allowing you to extract and analyze structured data directly from the command line.

When should I not use direct SQL command-line patterns for database operations?▼

Direct SQL command-line patterns should be avoided when your workflow strictly requires ORM-based abstractions for database interactions rather than raw relational database operations.

Related Skills

Explore More Software Engineering Skills→
bobmatnycbobmatnyc
68

prisma-orm

Generate type-safe Prisma clients and manage database migrations.

Community
Advanced
vikingokftvikingokft

recipe-backup-sheet-as-csv

Export Google Sheets spreadsheets to CSV for local backup.

Official
Intermediate
OKHP3OKHP3
2

okhp3-mermaid-data

Generate entity-relationship and class diagrams in Mermaid syntax for database schemas.

Community
Intermediate
wangx7wangx7

cloud-sql-basics

Provision and administer Cloud SQL instances for MySQL, PostgreSQL, and SQL Server.

Community
Intermediate