sql-toolkit
A comprehensive skill for working with relational databases, covering SQLite, PostgreSQL, and MySQL, with patterns for schema design, querying, migrations, indexing, and operations.
Overview
Query, design, migrate, and optimize SQL databases. Use when working with SQLite, PostgreSQL, or MySQL — schema design, writing queries, creating migrations, indexing, backup/restore, and debugging slow queries. No ORMs required.
Key Features
- Schema design and migration for SQLite, PostgreSQL, and MySQL
- Complex query writing (joins, aggregations, window functions, CTEs)
- Indexing and EXPLAIN for query optimization
- Backup and restore databases
- Quick data exploration with SQLite (zero setup)
How It Works
This skill provides a comprehensive toolkit for working with relational databases. It covers schema design, querying, migrations, indexing, and operations for SQLite, PostgreSQL, and MySQL. You can use it to create or modify database schemas, write complex queries, build migration scripts, optimize slow queries, back up and restore databases, and perform quick data exploration with SQLite.
Use Cases
- Creating a database schema for a new application
- Writing complex queries to retrieve data from a database
- Building migration scripts to update a database schema
- Optimizing slow queries with indexes and EXPLAIN
- Backing up and restoring a database
- Performing quick data exploration with SQLite
Reviews
No reviews yet.