skills.rest
Dev10x-Guru
Dev10x-GuruOFFICIAL
Explore all skills by this author →
WebsiteGitHub

Dev10x:db

Enforce schema-first construction and read-only safety for database queries.

7|2|Updated Apr 24, 2026
Search Tags:#database#read-only#schema-first#query planning#database safety
One-click install
npx skills add https://github.com/Dev10x-Guru/Dev10x-Claude --skill dev10x-db-dev10x-guru
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Dev10x:db
Source: https://github.com/Dev10x-Guru/Dev10x-Claude/tree/main/skills/db
Command: npx skills add https://github.com/Dev10x-Guru/Dev10x-Claude --skill dev10x-db-dev10x-guru

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses the issue of unsafe database queries by enforcing schema-first construction and read-only safety, ensuring accuracy and preventing modification of production data.

Core Features & Use Cases

  • Schema-first Construction: Ensures queries are accurate and do not modify production data.
  • Read-only Safety: Only SELECT, WITH (CTEs), EXPLAIN, and SHOW operations are allowed.
  • Query Planning Workflow: Provides a structured approach to query planning, including schema loading, table and column verification, and execution delegation.
  • Context Discovery Convention: Defines a clear convention for discovering database context, including schema files and configuration locations.
  • Safety Rules: Enforces read-only queries, use of timeouts, and limiting large result sets.
  • Anti-Patterns: Offers guidance on common pitfalls and best practices for database queries.
  • Schema Memory File Format: Defines a standard format for schema memory files.
  • Integration: Provides query planning guidance and delegates actual query execution to engine-specific skills.

Quick Start

Load schema context, verify table and column names, write the query, and execute it via the appropriate engine-specific skill.

Frequently Asked Questions about Dev10x:db

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

FAQPage Schema
How do I ensure read-only safety for database queries in production?▼

Read-only safety for database queries is enforced by restricting operations to SELECT, WITH (CTEs), EXPLAIN, and SHOW, preventing any modification of production data.

What is schema-first construction for database queries?▼

Schema-first construction for database queries involves loading schema context and verifying table and column names before writing queries, ensuring accuracy and preventing errors.

How do I plan database queries using a structured workflow?▼

Plan database queries by loading schema context, verifying table and column names, writing the query, and delegating execution to the appropriate engine-specific skill.

Can I execute write operations or modify data with this query planning approach?▼

You cannot execute write operations because the query planning approach enforces read-only safety rules, explicitly blocking any operations outside of SELECT, WITH, EXPLAIN, and SHOW.

What are common anti-patterns when writing database queries?▼

Common database query anti-patterns include bypassing schema verification, skipping query timeouts, and failing to limit large result sets, which compromise database safety and performance.

Do I need engine-specific skills to execute database queries?▼

You need engine-specific skills to execute database queries because the query planning workflow delegates actual execution to them after schema loading and verification are complete.

Related Skills

Explore More Software Engineering Skills→
ksk-incomksk-incom
5

macos-discovery

Identify macOS app configuration paths and generate YAML hints entries.

Community
Intermediate
OliverOuyangOliverOuyang
1

sql-runner

Execute SQL files via Dataphin MCP and export result sets as CSV files.

Community
Intermediate
djankiesdjankies

optimizing-query-selection

Select only required fields and load relations in Prisma queries.

Community
Advanced
ResgridResgrid
224

ef-core

Optimize Entity Framework Core LINQ queries and DbContext migration practices.

Official
Advanced