skills.rest
mattstyles333
mattstyles333COMMUNITY
Explore all skills by this author →
GitHub

sql-toolkit

Manage SQLite, PostgreSQL and MySQL databases via CLI without ORMs.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies complex database operations, allowing users to interact with SQL databases efficiently without needing deep expertise in specific database systems.

Core Features & Use Cases

  • Database Interaction: Query, design, and migrate schemas for SQLite, PostgreSQL, and MySQL.
  • Optimization: Analyze and improve query performance using indexing and EXPLAIN plans.
  • Backup & Restore: Manage database backups and restores across different SQL variants.
  • Use Case: You need to write a complex SQL query involving joins and aggregations for a PostgreSQL database, and then optimize it for better performance.

Quick Start

Use the sql-toolkit skill to connect to a PostgreSQL database and list all tables.

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 EXPLAIN plans?▼

To optimize PostgreSQL queries, this toolkit analyzes EXPLAIN plans and applies indexing strategies to improve execution speed. It helps interpret query plans and create indexes without ORM abstractions.

Can I write SQL migration scripts for both SQLite and MySQL without an ORM?▼

Yes, you can write migration scripts for SQLite and MySQL directly via command-line interaction. This toolkit facilitates schema design and migration scripting across SQL variants without ORM dependencies.

What is the best way to backup and restore a PostgreSQL database?▼

The best way to backup and restore PostgreSQL databases is using this toolkit's dedicated operations. It handles backup and restore processes across SQLite, PostgreSQL, and MySQL variants.

How do I design schemas and write complex SQL queries with joins and aggregations?▼

To design schemas and write complex SQL queries with joins and aggregations, this toolkit provides direct command-line interaction. It simplifies schema design and query writing across PostgreSQL, MySQL, and SQLite.

Does this SQL database toolkit support direct command-line interaction?▼

Yes, this SQL database toolkit supports direct command-line interaction for querying, designing, and migrating schemas. It bypasses ORM layers to interact directly with SQLite, PostgreSQL, and MySQL databases.

Related Skills

Explore More Software Engineering Skills→
diegoliriodiegolirio

setup-db-mcp

Configure MCP servers for database connectivity from a connection string.

Community
Advanced
MapleTechLabsMapleTechLabs
1.6k

chdb-sql

Execute ClickHouse SQL queries on local files and remote databases in Python.

Official
Intermediate
kk20300113-pngkk20300113-png

land-and-deploy

Merge pull requests and verify production health via canary checks.

Community
Advanced
NelkitNelkit
1

alembic-migration

Automate PostgreSQL schema changes with SQLAlchemy ORM and Alembic migrations.

Community
Intermediate