Sql Optimization Patterns
v1.0.0Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when de...
⭐ 0· 104·1 current·1 all-time
bynacy@watermelon11
MIT-0
Download zip
LicenseMIT-0 · Free to use, modify, and redistribute. No attribution required.
Security Scan
OpenClaw
Benign
high confidencePurpose & Capability
Name/description match the SKILL.md content: EXPLAIN analysis, indexing strategies, pagination, N+1 fixes, and example SQL/Python snippets. The skill requests no unrelated binaries, credentials, or installs.
Instruction Scope
Instructions stay within database optimization topics and include SQL and small client-side examples. They recommend running EXPLAIN/EXPLAIN ANALYZE and CREATE INDEX statements (which are expected). The doc does not instruct accessing files, environment variables, or external endpoints. It also lacks explicit warnings about running heavy ANALYZE or DDL statements on production systems—users should take standard DB safety precautions.
Install Mechanism
No install spec and no code files — the skill is instruction-only, so nothing will be written to disk or fetched during install.
Credentials
The skill declares no required environment variables, credentials, or config paths. That is proportional to a documentation/guide-style skill.
Persistence & Privilege
always:false and default model invocation are set. The skill does not request persistent presence or elevated platform privileges and does not modify other skills or system configs.
Assessment
This skill is essentially a documentation/guide for SQL optimization and appears internally consistent. Before using: (1) don't paste production DB credentials or connection strings into any chat unless you trust the agent and have vetted access controls; (2) run EXPLAIN/EXPLAIN ANALYZE and any suggested CREATE INDEX statements in a staging/replica environment first — EXPLAIN ANALYZE executes queries and can load production systems; (3) treat DDL (CREATE/ALTER INDEX) as changes that may need scheduling and careful rollback planning; (4) if you expect the agent to act autonomously, ensure policies prevent it from executing SQL directly against production without your approval. If you need higher assurance, ask the skill author for explicit safety notes about running statements on production and for example safeguards (transactions, timeouts, read-only replicas).Like a lobster shell, security has layers — review code before you run it.
latestvk9760ehbpz23fh2697va9xt3nx83ff2n
License
MIT-0
Free to use, modify, and redistribute. No attribution required.