sql-explain
v1.0.0Analyze and explain SQL query execution plans with optimization suggestions for PostgreSQL, MySQL, and SQLite databases.
⭐ 0· 35·1 current·1 all-time
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 contained code: the Python files implement formatting, simple syntax checks, NL→SQL templates, structure analysis, and parsing of EXPLAIN text. Minor mismatch: SKILL.md mentions using 'sqlean' explain module or broader DB EXPLAIN formats (Postgres/MySQL/SQLite), but the shipped implementation only uses sqlparse and regex-based parsing of EXPLAIN text (primarily PostgreSQL-style). The README/SKILL.md also mention saving history / Pro features, but no persistence or telemetry exists in the code.
Instruction Scope
Runtime instructions and SKILL.md limit actions to parsing/formatting/analysis of user-provided SQL or EXPLAIN text; code does not read unrelated files, environment variables, or make network calls. CLI offers local execution only.
Install Mechanism
No install spec in registry (instruction-only). The included code is pure Python and requires only the well-known 'sqlparse' package; no downloads, URLs, or archive extraction are present in the manifest.
Credentials
The skill requires no environment variables, credentials, or config paths. The requested surface is proportional to the stated functionality.
Persistence & Privilege
always is false and the skill does not modify other skills or system-wide settings. There is no code that writes persistent credentials or enables permanent background behavior.
Assessment
This skill appears to be a local, self-contained Python tool for formatting, basic syntax checking, NL→SQL templates, and parsing EXPLAIN text (mostly PostgreSQL-style). Before installing or running: (1) review the Python source provided (sql_explain.py and cli.py) yourself if you can — they are short and readable; (2) be aware the EXPLAIN parser is regex-based and may not fully support all MySQL/SQLite EXPLAIN variants despite the documentation claiming partial support; (3) the README/SKILL.md mention paid tiers and history saving, but no persistence/telemetry code is present — if you expect Pro features, ask the publisher how data/history are stored; (4) install only the dependency 'sqlparse' from PyPI and avoid running untrusted SQL on production databases. Overall the package is coherent and does not request extra privileges or secrets.Like a lobster shell, security has layers — review code before you run it.
clivk9797jsg90tbxxzjferf228yfh84bvbddatabasevk9797jsg90tbxxzjferf228yfh84bvbdlatestvk9797jsg90tbxxzjferf228yfh84bvbdsqlvk9797jsg90tbxxzjferf228yfh84bvbd
License
MIT-0
Free to use, modify, and redistribute. No attribution required.