skills.rest
GPTtang
GPTtangCOMMUNITY
Explore all skills by this author →
GitHub

sql-toolkit

Design schemas, write queries, and manage migrations for SQLite, PostgreSQL, and MySQL.

4|1|Updated Mar 14, 2026
Search Tags:#query optimization#database#postgresql#migrations#sqlite#sql#mysql
One-click install
npx skills add https://github.com/GPTtang/skill-atlas --skill sql-toolkit-gpttang
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-toolkit
Source: https://github.com/GPTtang/skill-atlas/tree/main/skills/devops/sql-toolkit
Command: npx skills add https://github.com/GPTtang/skill-atlas --skill sql-toolkit-gpttang

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill simplifies complex database operations, allowing you to query, design, migrate, and optimize SQL databases without needing to be a seasoned DBA.

Core Features & Use Cases

  • Database Interaction: Seamlessly work with SQLite, PostgreSQL, and MySQL.
  • Schema Management: Design new schemas, create tables, and add constraints.
  • Querying & Optimization: Write efficient SQL queries, analyze performance with EXPLAIN, and implement indexing strategies.
  • Migrations & Backups: Generate migration scripts and perform database backups and restores.
  • Use Case: You need to quickly analyze user activity data stored in a PostgreSQL database. Use this Skill to write a query that joins user information with order details, calculates monthly revenue, and identifies the top 10 customers.

Quick Start

Use the sql-toolkit skill to write a PostgreSQL query to select all columns from the 'users' table where the 'created_at' date is after '2026-01-01'.

Frequently Asked Questions about sql-toolkit

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

FAQPage Schema
How do I write a PostgreSQL query to join tables and calculate monthly revenue?▼

To write a PostgreSQL query for monthly revenue, you join user information with order details, aggregate the financial data, and sort the results to identify top customers. This process handles complex data relationships and calculates targeted metrics.

What's the best way to optimize SQL query performance using indexing and EXPLAIN?▼

Optimizing SQL query performance involves analyzing execution plans using EXPLAIN and implementing targeted indexing strategies. This approach identifies bottlenecks and accelerates data retrieval across PostgreSQL, MySQL, and SQLite databases.

How do I manage database migrations and perform backups for MySQL?▼

Managing database migrations for MySQL involves generating structured migration scripts to track schema changes. You can also perform full database backups and restores to ensure data integrity during deployment and recovery processes.

Can I use window functions and CTEs across SQLite, PostgreSQL, and MySQL?▼

Yes, you can use window functions and Common Table Expressions (CTEs) across SQLite, PostgreSQL, and MySQL. These advanced SQL features enable complex analytical patterns and hierarchical data querying within your existing database environment.

When do I need to query JSONB data in PostgreSQL?▼

You need to query JSONB data in PostgreSQL when storing flexible, semi-structured data alongside relational records. This approach allows dynamic document querying while maintaining the integrity of traditional table structures.

Related Skills

Explore More Software Engineering Skills→
Greenmamba29Greenmamba29

database-migrator

Migrate data and schemas between PostgreSQL, MySQL, SQLite, Supabase, and MongoDB.

Community
Advanced
gman-roboticsgman-robotics

data-analysis

Analyze Excel and CSV files with DuckDB SQL queries and export results.

Official
Intermediate
hannesillhannesill
40

m4-api

Access clinical datasets from Python and execute SQL queries to return DataFrames.

Community
Intermediate
hyukudanhyukudan
1

database-design

Guide database schema design for SQL and NoSQL systems.

Community
Advanced