skills.rest
marcoamu
marcoamuCOMMUNITY
Explore all skills by this author →
GitHub

sql-toolkit

Automate relational-database design, querying, and migrations across SQLite, PostgreSQL, and MySQL.

1|Updated Mar 14, 2026
Search Tags:#indexing#database#migrations#sql#query-optimization#schema-design
One-click install
npx skills add https://github.com/marcoamu/openclaw-workspace --skill sql-toolkit-marcoamu
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-toolkit
Source: https://github.com/marcoamu/openclaw-workspace/tree/main/skills/sql-toolkit
Command: npx skills add https://github.com/marcoamu/openclaw-workspace --skill sql-toolkit-marcoamu

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill simplifies and accelerates database work by providing best-practice guidance for designing schemas, writing efficient queries, and managing migrations across SQLite, PostgreSQL, and MySQL.

Core Features & Use Cases

  • Schema design patterns and data modeling tips for multiple engines.
  • Query optimization, indexing strategies, and performance troubleshooting.
  • Migration scripting and rollback guidance to safely evolve schemas.

Quick Start

Install the database engine of your choice and run the included sample SQL to create tables and start practicing migrations.

Frequently Asked Questions about sql-toolkit

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

FAQPage Schema
How do I optimize SQL queries and improve database performance?▼

SQL query optimization involves analyzing execution plans and applying indexing strategies to improve database performance. This skill provides guidance on indexing strategies and performance troubleshooting to resolve slow database queries across SQLite, PostgreSQL, and MySQL.

What is the best way to design a relational database schema?▼

Relational database schema design requires structuring tables and relationships to ensure data integrity. This skill offers schema design patterns and data modeling tips tailored for multiple database engines to structure your relational data effectively.

How do I write database migration scripts with rollback support?▼

Database migration scripting involves creating schema evolution scripts with rollback capabilities to safely manage changes. This skill provides migration scripting and rollback guidance to safely evolve schemas across SQLite, PostgreSQL, and MySQL.

Does this database toolkit work with PostgreSQL, MySQL, and SQLite?▼

Yes, this database toolkit works with PostgreSQL, MySQL, and SQLite. It provides cross-engine compatibility, allowing you to apply schema design, query optimization, and migration workflows seamlessly across these three relational database engines.

When should I add an index to a database table?▼

Indexing strategies are needed when database query performance degrades due to large table scans. This skill guides you through indexing strategies and performance troubleshooting to determine the optimal indexing approach for your relational database tables.

Can I manage multiple database engines with one workflow?▼

Managing multiple database engines within a single workflow requires cross-engine compatibility for schema design and migrations. This skill automates and guides relational database tasks across SQLite, PostgreSQL, and MySQL to standardize your database management.

Related Skills

Explore More Software Engineering Skills→
leonj1leonj1

rds-postgres

Connect to Amazon RDS PostgreSQL databases and execute SQL queries.

Community
Intermediate
jonnabiojonnabio
6

database-operations

Automate database migrations, schema changes, and query optimization.

Community
Advanced
hiddink-aihiddink-ai
1

alembic-best-practices

Standardize SQLAlchemy database migrations with safe schema evolution patterns.

Official
Advanced
raulnqraulnq

add-db-schema

Manage database schema changes and Drizzle ORM migrations for TypeScript projects.

Community
Intermediate