菜单
Query SQLite and PostgreSQL databases. Use when asked to run SQL queries, analyze database data, or explore database tables.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
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.
| 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.