rweisssieker-xp Query Contract Tester
Run:
node runtime/runTool.js query_contract_tester '{"sql":"SELECT id,total FROM orders LIMIT 50","contract":{"requiredColumns":["id","total"],"maxRows":100,"readOnly":true}}'
Returns contract status and violations.
Query Contract Tester
Validates SQL against query contracts such as required columns, max rows, and read-only expectations.
Query Contract Tester by rweisssieker-xp · 4101890
npx skillmds@latest add rweisssieker-xp/query-contract-tester File contents
---name: query-contract-testerdescription: Validates SQL against query contracts such as required columns, max rows, and read-only expectations.---# Query Contract TesterRun:```bashnode runtime/runTool.js query_contract_tester '{"sql":"SELECT id,total FROM orders LIMIT 50","contract":{"requiredColumns":["id","total"],"maxRows":100,"readOnly":true}}'```Returns contract status and violations.
rweisssieker-xp/sqlserver-postgres-plugin/tree/main/plugins/sqlserver-postgres-performance-advisor/skills/query-contract-tester commit 4101890021
Frequently asked questions
Run npx skillmds@latest add rweisssieker-xp/query-contract-tester in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.
Validates SQL against query contracts such as required columns, max rows, and read-only expectations. It is listed under Data & Analytics on SkillMD.
This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.
This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.
Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.
rweisssieker-xp (@rweisssieker-xp) published this skill. Their other Agent Skills are listed on their SkillMD profile.