skills.rest
wewetv1987-cell
wewetv1987-cellCOMMUNITY
Explore all skills by this author →
GitHub

sql-toolkit

Create, query, migrate, and tune SQLite, PostgreSQL, and MySQL databases.

Updated Feb 16, 2026
Search Tags:#query optimization#database#postgresql#migrations#sqlite#sql#mysql
One-click install
npx skills add https://github.com/wewetv1987-cell/openclaw-backup --skill sql-toolkit-wewetv1987-cell
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-toolkit
Source: https://github.com/wewetv1987-cell/openclaw-backup/tree/main/skills/sql-toolkit
Command: npx skills add https://github.com/wewetv1987-cell/openclaw-backup --skill sql-toolkit-wewetv1987-cell

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

SQL Toolkit removes the friction of working directly with relational databases by giving you one practical workflow for querying, designing, migrating, backing up, and optimizing data across SQLite, PostgreSQL, and MySQL.

Core Features & Use Cases

  • Schema Design and Editing: Create tables, constraints, indexes, and relationships with database-specific best practices.
  • Query Authoring and Analysis: Write joins, aggregations, CTEs, window functions, and recursive queries for real data exploration and reporting.
  • Operations and Performance: Run migrations, inspect execution plans, diagnose slow queries, and handle backup or restore tasks.
  • Use Case: A developer can use this Skill to prototype a SQLite database locally, port the schema to PostgreSQL, and then tune an expensive query with indexes after checking the execution plan.

Quick Start

Ask the skill to design a relational schema, write the SQL you need, and show the exact command-line steps for running it in SQLite, PostgreSQL, or MySQL.

Frequently Asked Questions about sql-toolkit

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

FAQPage Schema
How do I optimize slow PostgreSQL queries using execution plans?▼

To optimize slow PostgreSQL queries, inspect the execution plan to identify bottlenecks, then apply indexing and query tuning. This skill supports query-plan inspection and slow-query analysis to diagnose and resolve relational database performance issues.

What is the best way to migrate a SQLite schema to PostgreSQL?▼

Migrating a SQLite schema to PostgreSQL involves generating migration scripts and applying database-specific syntax. This skill handles migration scripting and schema design to ensure safe, portable relational database operations across SQLite, PostgreSQL, and MySQL.

Can I write recursive CTEs and window functions for MySQL reporting?▼

Yes, you can write recursive CTEs and window functions for MySQL reporting. This skill supports query authoring for joins, aggregations, CTEs, and window functions to enable real relational data exploration and reporting.

How do I design relational database tables with constraints and indexes?▼

Designing relational database tables requires creating tables, constraints, indexes, and relationships. This skill provides schema design and editing with database-specific best practices for SQLite, PostgreSQL, and MySQL workflows.

Does this SQL toolkit support command-line backup and restore workflows?▼

Yes, this SQL toolkit supports command-line backup and restore workflows. It provides direct command-line execution steps for safe, portable operations across SQLite, PostgreSQL, and MySQL databases.

Related Skills

Explore More Software Engineering Skills→
ltdrewltdrew
1

setup

Provision GBrain databases and inject the brain-first lookup protocol into AGENTS.md.

Community
Advanced
gman-roboticsgman-robotics

data-analysis

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

Official
Intermediate
delta-and-betadelta-and-beta

analyst-business-intelligence

Configure BI dashboards and reporting pipelines using Braze data exports.

Community
Intermediate
AnasAhmed001AnasAhmed001
1

database-specialist

Design scalable SQL and NoSQL database schemas with migrations and indexing.

Community
Advanced