mikevan666/OpenDataWorks Readonly SQL
skills/platform/opendataworks-readonly-sql/SKILL.md
Use this built-in skill to execute readonly SQL through the OpenDataWorks agent API and shared odw-cli. Guardrails such as readonly checks, datasource scope, default limit, and timeout are enforced by CLI and API.
$ install --global
skillsauthnpx skillsauth add mikevan666/opendataworks OpenDataWorks Readonly SQLInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 16, 2026, 5:58 AM6.8s2 files scanned
SKILL.md
- name:
- OpenDataWorks Readonly SQL
- description:
- Use this built-in skill to execute readonly SQL through the OpenDataWorks agent API and shared odw-cli. Guardrails such as readonly checks, datasource scope, default limit, and timeout are enforced by CLI and API.
- category:
- Platform
- version:
- v1
OpenDataWorks Readonly SQL Skill
Use this skill when the user needs SQL execution against OpenDataWorks platform data or metadata-resolved business databases.
Execution contract:
- Always use
python3 scripts/run_readonly_sql.py. - The real boundary is enforced by
odw-cli + backend-agent-api. - Do not duplicate read-only policy logic in prompt text or hand-written SQL wrappers.
What the API and CLI guarantee:
- only readonly SQL
- platform database
opendataworksis allowed - business databases resolved by metadata are allowed
- default row limit is
200 - default timeout is
30s
Recommended flow:
- If the target table or database is unclear, first use
OpenDataWorks Platform Skill. - Once the database and SQL are clear, execute:
python3 scripts/run_readonly_sql.py --database "<db>" --sql "<sql>"
- Summarize the result before proposing any further analysis or charting.
Related Skills
mikevan666/OpenDataWorks Platform
data-ai
VerifiedTrustedCommunity
Use this built-in skill for OpenDataWorks platform metadata, lineage, datasource resolution, and DDL lookup. This skill does not execute SQL for data analysis.
17SKILL.mdUpdated Apr 16, 2026
mikevan666/Smoke
testing
VerifiedTrustedCommunity
A minimal smoke skill used to verify that opendataagent can load bundled skills and surface them during chat.
17SKILL.mdUpdated Apr 16, 2026
mikevan666/Python Analysis
development
VerifiedTrustedCommunity
Use this built-in skill for lightweight Python-based data exploration, profiling, aggregation, and file-based analysis. It does not fetch OpenDataWorks metadata on its own.
17SKILL.mdUpdated Apr 16, 2026
mikevan666/Chart Visualization
data-ai
VerifiedTrustedCommunity
Use this built-in skill for chart construction and data storytelling from structured tabular results. The workflow is organized from the AntV chart-visualization playbook, but current default output is ECharts-compatible option JSON for local rendering.
17SKILL.mdUpdated Apr 16, 2026