Generate, optimize, and explain SQL queries for PostgreSQL, MySQL, SQLite, and SQL Server.
npx skills add https://github.com/ntaksh42/agents --skill sql-query-helper
Please help me install this Agent Skill. Skill: sql-query-helper Source: https://github.com/ntaksh42/agents/tree/main/.claude/skills/sql-query-helper Command: npx skills add https://github.com/ntaksh42/agents --skill sql-query-helper
This Skill streamlines the process of writing, refining, and understanding SQL queries, ensuring efficiency and accuracy in database interactions.
CREATE TABLE statements for various database systems.Generate a SQL query to list users who made more than 3 orders in 2024, sorted by order count descending.
High-intent search queries and answers about installing and using this skill.
SQL generation converts plain English descriptions directly into executable database queries. You describe the desired data logic, and the system outputs the corresponding SQL statement for PostgreSQL, MySQL, SQLite, or SQL Server.
Query optimization identifies inefficiencies like N+1 problems and resolves them by restructuring the SQL and suggesting appropriate index usage. This process improves execution speed and reduces database load across supported systems.
Query explanation translates intricate SQL statements into human-readable summaries detailing execution flow and logic. It also includes EXPLAIN plan analysis to break down how the database engine processes the query.
Yes, DDL generation automates the creation of CREATE TABLE statements. It supports multiple database systems including PostgreSQL, MySQL, SQLite, and SQL Server, ensuring schema setup matches your specific environment.
Yes, the tool fully supports PostgreSQL and SQL Server alongside MySQL and SQLite. It handles query generation, optimization, and explanation tailored to the specific syntax and performance characteristics of each platform.
Analyzing an EXPLAIN plan involves reviewing the execution steps to detect bottlenecks like full table scans or missing indexes. The system interprets the plan and recommends index optimizations to resolve performance issues.
trueraCreate and curate ground-truth evaluation datasets for TruLens.
OliverOuyangExecute SQL files via Dataphin MCP and export result sets as CSV files.
PlazaCCGenerate and apply Drizzle ORM migration scripts for Supabase Postgres.
EstomAnalyze slow PostgreSQL and MySQL queries and optimize execution plans.