skills.rest
wooyek
wooyekCOMMUNITY
Explore all skills by this author →
Website𝕏@wooyekGitHub

dev10x-db

Enforces schema-first, SELECT-only database queries for Claude Code.

Updated Aug 27, 2026
Search Tags:#database#schema#safety#sql#read-only#query planning
One-click install
npx skills add https://github.com/wooyek/dev10x-ai --skill dev10x-db
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dev10x-db
Source: https://github.com/wooyek/dev10x-ai/tree/main/codex-skills/dev10x-db
Command: npx skills add https://github.com/wooyek/dev10x-ai --skill dev10x-db

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill ensures that when querying any database, the process is schema-first and read-only safe, guaranteeing accurate queries that never modify production data.

Core Features & Use Cases

  • Schema-First Query Construction: Prioritizes understanding the database schema before writing SQL.
  • Read-Only Safety: Prevents accidental data modification by enforcing SELECT-only operations through automated tools.
  • Context Discovery: Automatically finds project-specific database context from memory files, project skills, or CLAUDE.md.
  • Use Case: Securely retrieve customer data for a report without any risk of altering live records.

Quick Start

Load the schema context for the 'orders' database and then write a SELECT query to find all orders placed in the last week.

Frequently Asked Questions about dev10x-db

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I plan safe SQL queries without modifying production data?▼

Safe SQL query planning enforces schema-first construction and read-only safety rules, ensuring queries use SELECT-only operations and statement timeouts to retrieve data without altering production records.

How does schema-first database query construction work?▼

Schema-first query construction prioritizes understanding the database schema before writing SQL, automatically discovering project-specific database context from memory files, project skills, or CLAUDE.md to ensure accurate queries.

Can I use read-only SQL queries to safely retrieve customer data for reports?▼

Yes, read-only SQL queries enforce SELECT-only operations through automated tools, allowing you to securely retrieve customer data for a report without any risk of altering live records.

What are the limitations of enforcing read-only database query planning?▼

Read-only database query planning is limited to SELECT-only operations and cannot execute data modification commands, additionally requiring statement timeouts and limiting result set sizes to maintain safety.

Do I need to load schema context before writing SQL queries?▼

Yes, loading schema context is required before writing SQL queries to ensure schema-first construction, allowing the system to automatically find project-specific database context from memory files or CLAUDE.md.

Related Skills

Explore More Software Engineering Skills→
JeffallanJeffallan
10.9k

sql-pro

Optimize SQL queries and schemas across PostgreSQL, MySQL, SQL Server, and Oracle.

Community
Advanced
Akhan521Akhan521
1

query-writing

Convert natural-language questions into validated, read-only SQL queries and execute them.

Community
Intermediate
DevHive1DevHive1
18

database

Provision PostgreSQL databases and execute safe SQL queries across environments.

Community
Advanced
hongmaple0820hongmaple0820
9

postgres

Run read-only SELECT, EXPLAIN, and SHOW queries across configured PostgreSQL databases.

Community
Intermediate