skills.rest
winsorllc
winsorllcCOMMUNITY
Explore all skills by this author →
GitHub

database-tools

Manage SQLite and PostgreSQL databases with querying, schema inspection, and backup tools.

1|Updated Feb 25, 2026
Search Tags:#database#postgresql#migration#sqlite#backup#sql#query
One-click install
npx skills add https://github.com/winsorllc/upgraded-carnival --skill database-tools
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-tools
Source: https://github.com/winsorllc/upgraded-carnival/tree/main/.pi/skills/database-tools
Command: npx skills add https://github.com/winsorllc/upgraded-carnival --skill database-tools

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill provides a comprehensive set of tools and commands for managing and interacting with both SQLite and PostgreSQL databases, simplifying common database operations.

Core Features & Use Cases

  • Database Querying: Execute SQL queries for data retrieval and manipulation.
  • Schema Management: View table structures, indexes, and sequences.
  • Data Import/Export: Easily import data from CSV files and export data to various formats.
  • Backup and Restore: Perform full database backups and restores for SQLite and PostgreSQL.
  • Migrations: Examples for creating and managing database schema changes.
  • Performance Analysis: Tools to explain query plans and identify slow queries.
  • Health Checks: Scripts to assess the health and performance of SQLite and PostgreSQL databases.

Quick Start

Use the database-tools skill to connect to and query the 'my.db' SQLite database.

Frequently Asked Questions about database-tools

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

FAQPage Schema
How do I manage SQLite and PostgreSQL databases from the command line?▼

You can execute SQL queries, inspect schemas, import and export data, and perform backup and restore operations for both SQLite and PostgreSQL databases using command-line scripts.

Can I run database health checks and analyze query performance for PostgreSQL?▼

Yes, you can assess database health and analyze query performance using built-in tools to explain query plans and identify slow PostgreSQL queries.

What do I need to import CSV files and export data from my database?▼

You need command-line access to SQLite3 and PostgreSQL clients to import data from CSV files and export data to various formats using the provided scripts.

Does this tool support database migrations and schema management for SQLite?▼

Yes, it provides examples for creating and managing database schema changes, allowing you to view table structures, indexes, and sequences for SQLite databases.

What is the best way to back up and restore SQLite and PostgreSQL databases?▼

You can perform full database backups and restores for both SQLite and PostgreSQL by executing the dedicated backup and restore scripts included in the toolset.

Related Skills

Explore More Software Engineering Skills→
bug-opsbug-ops
55

database

Run SQL queries and database administration across SQLite, PostgreSQL, and MySQL via CLI.

Community
Intermediate
UnicornUnicorn

query-optimization-agent

Analyze SQL queries and produce rewritten SQL, index recommendations, and execution plan comparisons.

Official
Intermediate
PlazaCCPlazaCC
2

db-migrate

Generate and apply Drizzle ORM migration scripts for Supabase Postgres.

Official
Intermediate
winsorllcwinsorllc

db-tool

Query and manage SQLite, PostgreSQL, and MySQL databases via a unified CLI.

Community
Intermediate