Requirements
- Target platform
- OpenClaw
- Install method
- Manual import
- Extraction
- Extract archive
- Prerequisites
- OpenClaw
- Primary doc
- SKILL.md
Run safe read-only queries against MySQL or PostgreSQL for data inspection, reporting, and troubleshooting. Use when the user asks to read tables, inspect schema, count rows, sample data, or export query results without modifying data.
Run safe read-only queries against MySQL or PostgreSQL for data inspection, reporting, and troubleshooting. Use when the user asks to read tables, inspect schema, count rows, sample data, or export query results without modifying data.
Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.
I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Tell me what you changed and call out any manual steps you could not complete.
I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Summarize what changed and any follow-up checks I should run.
Use this skill for database read tasks only.
Connect to PostgreSQL or MySQL using connection env vars Execute SELECT / WITH / EXPLAIN queries only Optionally save output to CSV/TSV/JSON Block risky SQL (INSERT, UPDATE, DELETE, DROP, ALTER, etc.)
PGHOST PGPORT (optional, default 5432) PGDATABASE PGUSER PGPASSWORD
MYSQL_HOST MYSQL_PORT (optional, default 3306) MYSQL_DATABASE MYSQL_USER MYSQL_PASSWORD
Use script: scripts/db_readonly.sh postgres "SELECT now();" scripts/db_readonly.sh mysql "SELECT NOW();" Export example: scripts/db_readonly.sh postgres "SELECT * FROM users LIMIT 100" --format csv --out /tmp/users.csv
Refuse non-read SQL. Prefer LIMIT for exploratory queries. When user asks for updates/deletes/schema changes, ask explicit confirmation and do not run via this skill. Avoid printing secrets from env vars.
Query cookbook: references/query-cookbook.md
Data access, storage, extraction, analysis, reporting, and insight generation.
Largest current source with strong distribution and engagement signals.