- Home
- Skills
- Research & Analysis
- sql analytical query builder
Works with the AI Agents you already use
sql analytical query builder
Drafts a read-only, parameterised SQL SELECT for PostgreSQL, MySQL, SQLite, SQL Server, BigQuery or Snowflake from an approved schema and permission scope.
$1.99
About this skill
Drafts a read-only, parameterised SQL SELECT for PostgreSQL, MySQL, SQLite, SQL Server, BigQuery or Snowflake from an approved schema and permission scope. Checks access, joins, fan-out and performance, and compares fixtures. Never runs SQL.
What it does
Builds one read-only, parameterised SQL SELECT for a stated dialect (PostgreSQL, MySQL, SQLite, SQL Server, BigQuery, Snowflake) from a business question turned into a structured query, an approved schema and a permission scope. Covers joins, CTEs, window functions, aggregation, row-scope and sensitive-column controls, fan-out and performance flags, output schema and fixture comparison. Refuses destructive SQL; never runs it. Use when asked to write, draft or validate an analytical query. Not for explaining existing SQL.
Use cases
- Draft one read-only, parameterised SELECT statement from a business question and an approved schema.
- Check joins, fan-out and performance in a draft query and flag any access or scope problems.
- Compare query output against supplied fixtures and list the outcome for review.
What is included
SKILL.md: the workflow, trigger rules and output format.references/: method notes and the markers used in outputs, loaded only when needed.scripts/run.py: one self-contained Python script (standard library only) that does every calculation deterministically.assets/: input and output schemas with a sample request and result.
Limits
Decision support only. Outputs label analytical estimates, information gaps and actions that need human approval. The skill does not send, publish, pay or change anything by itself, and it does not claim legal, regulatory or standards compliance.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 2 days ago