skills.rest
sigitpoerwo
sigitpoerwoCOMMUNITY
Explore all skills by this author →
GitHub

sql-toolkit

Design and optimize SQL schemas and migrations across SQLite, PostgreSQL, and MySQL.

Updated Mar 29, 2026
Search Tags:#postgresql#migrations#patterns#sqlite#sql#mysql#query-optimization
One-click install
npx skills add https://github.com/sigitpoerwo/repoworkspace_zahra --skill sql-toolkit-sigitpoerwo
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-toolkit
Source: https://github.com/sigitpoerwo/repoworkspace_zahra/tree/main/skills/01-SIAP-PAKAI/coding/sql-toolkit
Command: npx skills add https://github.com/sigitpoerwo/repoworkspace_zahra --skill sql-toolkit-sigitpoerwo

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides practical guidance for designing robust SQL schemas, performing safe migrations, and optimizing queries across SQLite, PostgreSQL, and MySQL.

Core Features & Use Cases

  • Cross-engine patterns: portable schema design, migrations, and performance tuning with engine-specific notes.
  • Advanced SQL techniques: indexing strategies, window functions, common table expressions, and JSON-like data handling.
  • Use Case: Build and migrate a multi-tenant catalog with safe rollbacks and optimized reads.

Quick Start

Create a simple users table, add an index, and run a sample query to observe performance improvements.

Frequently Asked Questions about sql-toolkit

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

FAQPage Schema
How do I design portable SQL schemas that work across SQLite, PostgreSQL, and MySQL?▼

To design portable SQL schemas across SQLite, PostgreSQL, and MySQL, apply cross-engine patterns that enforce portable practices while accommodating engine-specific notes for indexing and JSON-like data handling.

What is the best way to perform safe SQL database migrations with rollbacks?▼

Safe SQL database migrations require applying portable schema designs with support for safe rollbacks, ensuring you can build and migrate structures like multi-tenant catalogs without data loss.

How do I optimize SQL queries using indexing and window functions?▼

Optimize SQL queries by applying advanced techniques like indexing strategies, window functions, and common table expressions, guided by performance-focused tuning specific to your database engine.

Can I handle JSON-like data structures consistently in PostgreSQL and MySQL?▼

Yes, you can handle JSON-like data consistently by applying cross-engine patterns for JSON-like data handling, which provides portable practices for real-world applications across SQLite, PostgreSQL, and MySQL.

Does this SQL toolkit support building multi-tenant catalogs with optimized reads?▼

Yes, the SQL toolkit supports building and migrating multi-tenant catalogs by enforcing portable practices, supporting safe migrations, and providing performance-focused guidance for optimized reads.

Related Skills

Explore More Software Engineering Skills→
ripgraphicsripgraphics

database-expert

Analyze database query plans and optimize performance across PostgreSQL, MySQL, MongoDB, and SQLite.

Community
Advanced
JesusFigueroa25JesusFigueroa25

Database Optimizer

Optimize PostgreSQL and MySQL database performance through schema, query, and indexing analysis.

Community
Advanced
cpa03cpa03

database-migration-create

Create and apply versioned SQL migrations with rollback plans.

Community
Intermediate
ViewWayViewWay

SQL

Design schemas, write portable SQL, and coordinate migrations across PostgreSQL, MySQL, SQLite, and SQL Server.

Community
Advanced