skills.rest
darblex
darblexCOMMUNITY
Explore all skills by this author →
GitHub

sql-toolkit

Interact with SQLite, PostgreSQL, and MySQL databases via command-line operations.

Updated Mar 10, 2026
Search Tags:#database#optimization#sqlite#sql#query#mysql#postgres
One-click install
npx skills add https://github.com/darblex/price-compare-israel --skill sql-toolkit-darblex
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-toolkit
Source: https://github.com/darblex/price-compare-israel/tree/main/workspace/skills/sql-toolkit
Command: npx skills add https://github.com/darblex/price-compare-israel --skill sql-toolkit-darblex

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a comprehensive command-line toolkit for interacting with SQL databases, simplifying tasks from schema design to query optimization.

Core Features & Use Cases

  • Database Interaction: Connect to and query SQLite, PostgreSQL, and MySQL databases directly.
  • Schema Management: Design, create, and modify database schemas.
  • Querying & Optimization: Write complex queries, optimize performance with indexing and EXPLAIN.
  • Migrations & Backups: Manage database schema evolution and perform backup/restore operations.

Quick Start

Use the sql-toolkit skill to connect to a PostgreSQL database named 'mydb' using user 'myuser' on localhost.

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 query performance using EXPLAIN and indexing?▼

SQL query performance optimization is achieved by analyzing execution plans with EXPLAIN and implementing proper indexing strategies. This toolkit supports writing complex queries and debugging performance issues for SQLite, PostgreSQL, and MySQL databases.

How do I manage database schema migrations for PostgreSQL?▼

Database schema migrations for PostgreSQL are managed directly via command-line scripts. You can design, modify, and track schema evolution deterministically, ensuring consistent database state transitions across environments.

Can I interact with SQLite, MySQL, and PostgreSQL databases from the command line?▼

Direct command-line interaction with SQLite, MySQL, and PostgreSQL databases is fully supported. You can connect to local instances, retrieve in-depth information from references, and execute deterministic scripts for schema design and querying.

What is the best way to perform database backup and restore operations?▼

Database backup and restore operations are executed through command-line scripts. This approach allows deterministic task execution, ensuring reliable backups and accurate restoration for your SQL databases.

Do I need specific drivers to connect to a MySQL database?▼

Connecting to a MySQL database requires standard command-line access to the database instance. The toolkit facilitates direct interaction without additional dependencies, utilizing built-in references for query execution and schema management.

Related Skills

Explore More Software Engineering Skills→
kubiyabotkubiyabot
16

postgres

Run PostgreSQL queries and admin tasks via the psql CLI.

Official
Advanced
KrishnatejavepaKrishnatejavepa
14

port

Import, export, back up, and migrate a cofounder's knowledge and skills.

Community
Advanced
MinhmiceMinhmice

database-specialist

Designs and migrates database schemas, policies and queries for SQL-based systems.

Community
Intermediate
hypeJunctionhypeJunction
1

prisma-guidelines

Provide Prisma ORM best practices for schema design, query optimization, and migrations.

Community
Intermediate