Agent skill · data analytics · aiskillstore
sql-queries
Expert SQL query generation for DBX Studio. Use when writing, optimizing, or debugging SQL queries against user database connections.
Why this skill is useful
Provides specific SQL query patterns and safety rules tailored for DBX Studio that the AI wouldn't reliably generate on its own.
What it needs
About 1k tokens when loaded. Last updated 2026-08-07. 405 stars on the source repository.
What this skill does
SQL Query Expert — DBX Studio This project supports multiple database backends via user connections. Always write dialect-appropriate SQL. Supported Dialects Dialect Provider --------- ---------- PostgreSQL Default / Railway Snowflake Via MCP connector BigQuery Via MCP connector Databricks Via MCP connector MySQL Via connection string SQLite Via connection string Query Patterns Safe SELECT with limit Always add LIMIT unless the user explicitly wants all rows: CTEs for complex queries Aggregations Window Functions Tool Usage in DBX Studio AI The AI has access to these tools — always use them rather than guessing: Tool When to Use ------ ------------- readschema First call — understand table structure gettabledata Preview rows before writing complex queries executequery Run SELECT queries (SELECT/WITH only) describetable Get column details, FK relationships gettablestats Row counts, distributions generatechart Visualize query results Query Safety Rules Only SELECT and WITH (CTEs) are permitted via executequery Always quote identifiers: "schema"."table"."column" Add LIMIT automatically unless the user asks for all data Validate table/column names exist via readschema or describetable first Response Format 1. Execute tool to get data 2. Answer the user's question directly with the result 3. Show SQL in `sql blocks only if the user asks "how" or "show me the query" 4. Present numbers clearly: "There are 1,247 orders this month"
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aiskillstore/sql-queries