Menu
Query SQLite and PostgreSQL databases. Use when asked to run SQL queries, analyze database data, or explore database tables.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
| name | sql-query |
| description | Query SQLite and PostgreSQL databases. Use when asked to run SQL queries, analyze database data, or explore database tables. |
| allowed-tools | Bash |
Execute SQL queries against SQLite or PostgreSQL databases.
~/.claude/skills/sql-query/sql.sh sqlite /path/to/db.sqlite "SELECT * FROM users LIMIT 10"
~/.claude/skills/sql-query/sql.sh postgres "postgresql://user:pass@host/db" "SELECT * FROM users"
# Default: formatted table
~/.claude/skills/sql-query/sql.sh sqlite db.sqlite "SELECT * FROM users"
# CSV output
~/.claude/skills/sql-query/sql.sh sqlite db.sqlite "SELECT * FROM users" --csv
# JSON output
~/.claude/skills/sql-query/sql.sh sqlite db.sqlite "SELECT * FROM users" --json
-- List tables (SQLite)
SELECT name FROM sqlite_master WHERE type='table';
-- Show table schema
PRAGMA table_info(tablename);
-- Count rows
SELECT COUNT(*) FROM tablename;
Read-only by default (SELECT only). Use --write flag to enable INSERT/UPDATE/DELETE.
Convert files between formats (PDF to text, Markdown to HTML, JSON to CSV, CSV to JSON). Use when asked to convert, transform, or export files to different formats.
Persistent memory with semantic search - store and recall information across sessions. Use when asked to remember something, recall previous discussions, or manage long-term memory. Also use proactively to store important discoveries and compact context.
Install software packages at runtime in the Docker container. Use when a required tool or library is missing, or when asked to install packages.
MANDATORY final step. Validates task completion through testing and QA before allowing stop.
Track tasks for the current work session. Use this to break down work into steps and track progress. ALWAYS use this when starting a new task - add items first, then mark them done as you complete them.
Analyze images using vision AI model. Use for UI screenshot verification, understanding downloaded images/assets, reading text from pictures (OCR), or any visual analysis task.