본문으로 건너뛰기
TakoAPI
스킬로 돌아가기

db-readonly

reed1898 제작

Browser & Automation
835clawskills.sh가 보고한 다운로드 수
0조회수
좋아요 0개로그인하면 이 스킬에 좋아요를 누를 수 있습니다
—아직 평가 없음
내 평가

요약

Run safe read-only queries against MySQL or PostgreSQL for data inspection, reporting, and troubleshooting.

설명

이 스킬이 하는 일

Runs read-only queries against PostgreSQL or MySQL databases. Supports SELECT, WITH, and EXPLAIN statements, and can export results to CSV, TSV, or JSON. Blocks INSERT, UPDATE, DELETE, DROP, and ALTER to prevent accidental data modification.

Enforces read-only access at the skill level, so exploratory database work can't accidentally modify or delete data.

사용 시점

  • Inspecting table schemas before writing a migration
  • Counting rows to verify a data import completed
  • Sampling user records to debug a reported issue
  • Exporting query results to CSV for a stakeholder report
  • Running EXPLAIN on a slow query to diagnose performance

예시 워크플로

입력

User asks: Show me the 10 most recent orders with their totals

에이전트
  1. 1

    Reads PGHOST, PGDATABASE, PGUSER, PGPASSWORD from environment

  2. 2

    Constructs a SELECT query with ORDER BY created_at DESC and LIMIT 10

  3. 3

    Runs scripts/db_readonly.sh postgres with the query

  4. 4

    Returns the result rows to the user

출력

A table of 10 order rows showing id, created_at, and total columns

요구 사항

  • PostgreSQL connection environment variables: PGHOST, PGDATABASE, PGUSER, PGPASSWORD
  • MySQL connection environment variables: MYSQL_HOST, MYSQL_DATABASE, MYSQL_USER, MYSQL_PASSWORD

설치

clawhub install reed1898/db-readonly

CLI 명령을 실행하거나, 프롬프트를 Claude Code, Cursor, Codex 등 사용하는 코딩 에이전트에 붙여넣으세요.

링크