Generate, optimize, and debug SQL queries across multiple database dialects.
npx skills add https://github.com/Dbxstudio/dbx-studio --skill sql-queries-dbxstudio
Please help me install this Agent Skill. Skill: sql-queries Source: https://github.com/Dbxstudio/dbx-studio/tree/main/.claude/skills/sql-queries Command: npx skills add https://github.com/Dbxstudio/dbx-studio --skill sql-queries-dbxstudio
This Skill assists users in writing, optimizing, and debugging SQL queries for various database systems, ensuring dialect-appropriate and safe query generation.
read_schema, get_table_data, and execute_query for accurate query development.read_schema to understand the orders and customers tables, then execute_query with a safe SELECT statement including a LIMIT to retrieve the data.Use the sql-queries skill to generate a safe SELECT query with a limit of 100 rows from the 'users' table.
High-intent search queries and answers about installing and using this skill.
To generate SQL queries from natural language, you describe the desired data retrieval in plain text. The tool translates your description into a dialect-appropriate SQL query, automatically quoting identifiers and adding LIMIT clauses to ensure safe execution.
Yes, you can write and optimize SQL for both Snowflake and PostgreSQL. It supports multiple database dialects, adapting the generated queries to the specific syntax and functions required by systems like Snowflake, PostgreSQL, BigQuery, Databricks, MySQL, and SQLite.
Query safety is enforced by automatically applying LIMIT clauses to prevent excessively large result sets and properly quoting identifiers to avoid syntax errors. It also integrates with schema reading and query execution tools to validate structure before running.
The best way to debug a failing SQL query is to leverage the integrated schema reading tool. By analyzing the table structures and integrating query execution, the tool identifies structural mismatches, applies correct identifier quoting, and optimizes the query logic.
You need accurate database schema details to generate correct SQL queries. The tool integrates with a read_schema function to automatically retrieve table structures, ensuring the generated queries match your actual columns, relationships, and data types.
Your generated SQL query includes an automatic LIMIT clause as a built-in safety mechanism. This precaution prevents accidentally retrieving massive datasets during query execution, ensuring database stability and protecting against performance degradation.
ccfosTranslate natural language descriptions into executable SQL queries for database analysis.
hannesillAccess clinical datasets from Python and execute SQL queries to return DataFrames.
robkiskCreate and update Databricks AI/BI dashboards with SQL validation and deployment.
marquesfelipIdentify and fix SQL injection vulnerabilities in data access layers.