db-readonlyRun 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.
Install via ClawdBot CLI:
clawdbot install reed1898/db-readonlyUse this skill for database read tasks only.
INSERT, UPDATE, DELETE, DROP, ALTER, etc.)PGHOSTPGPORT (optional, default 5432)PGDATABASEPGUSERPGPASSWORDMYSQL_HOSTMYSQL_PORT (optional, default 3306)MYSQL_DATABASEMYSQL_USERMYSQL_PASSWORDUse 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.csvLIMIT for exploratory queries.references/query-cookbook.mdGenerated Mar 1, 2026
Retrieve daily sales data, customer order counts, and product performance metrics from a PostgreSQL database for generating reports without risking data modification. Useful for marketing teams to analyze trends and optimize campaigns.
Query a MySQL database to inspect patient records, count appointments, and sample anonymized data for compliance audits and troubleshooting. Ensures data integrity by blocking any updates or deletions during inspection.
Run read-only queries on a PostgreSQL database to monitor transaction logs, detect anomalies, and export results to CSV for further analysis. Supports safe data inspection for fraud detection teams.
Use this skill to query database logs stored in MySQL, such as error counts or user activity, for troubleshooting system issues. Helps IT teams diagnose problems without altering production data.
Inspect student enrollment data and course registrations from a PostgreSQL database to generate reports on demographics and attendance. Enables administrators to make data-driven decisions safely.
Integrate this skill into a subscription-based analytics service that provides read-only database access for clients to generate custom reports and dashboards. Revenue is generated through monthly or annual licensing fees.
Offer database inspection and troubleshooting services using this skill to help businesses audit data, optimize queries, and ensure compliance. Revenue comes from project-based contracts or hourly consulting rates.
Develop and sell a tool that leverages this skill to safely export database query results to formats like CSV or JSON for data migration or backup purposes. Revenue is generated through one-time purchases or tiered pricing.
💬 Integration Tip
Ensure environment variables are securely set and use the provided scripts to execute queries, avoiding manual SQL input to maintain safety.
Use the @steipete/oracle CLI to bundle a prompt plus the right files and get a second-model review (API or browser) for debugging, refactors, design checks, or cross-validation.
Manage Things 3 via the `things` CLI on macOS (add/update projects+todos via URL scheme; read/search/list from the local Things database). Use when a user asks Clawdbot to add a task to Things, list inbox/today/upcoming, search tasks, or inspect projects/areas/tags.
Local search/indexing CLI (BM25 + vectors + rerank) with MCP mode.
Use when designing database schemas, writing migrations, optimizing SQL queries, fixing N+1 problems, creating indexes, setting up PostgreSQL, configuring EF Core, implementing caching, partitioning tables, or any database performance question.
Connect to Supabase for database operations, vector search, and storage. Use for storing data, running SQL queries, similarity search with pgvector, and managing tables. Triggers on requests involving databases, vector stores, embeddings, or Supabase specifically.
Query, design, migrate, and optimize SQL databases. Use when working with SQLite, PostgreSQL, or MySQL — schema design, writing queries, creating migrations, indexing, backup/restore, and debugging slow queries. No ORMs required.