skills.rest
d0d012
d0d012COMMUNITY
Explore all skills by this author →
GitHub

sql-assistant

Analyze SQL query plans and provide dialect-aware optimization recommendations.

9|Updated Apr 11, 2026
Search Tags:#performance#debugging#optimization#sql#indexes#dialects#query-analysis
One-click install
npx skills add https://github.com/d0d012/claude-trim --skill sql-assistant
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-assistant
Source: https://github.com/d0d012/claude-trim/tree/main/testdata/demo/plugins/db-plugin/skills/sql-assistant
Command: npx skills add https://github.com/d0d012/claude-trim --skill sql-assistant

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Helps developers write, optimize, and debug SQL queries by providing guidance on best practices, performance improvements, and dialect-aware recommendations.

Core Features & Use Cases

  • SQL writing guidance and best-practice recommendations
  • Query plan analysis with indexing suggestions and performance tuning
  • Dialect translation and cross-database compatibility checks
  • Real-world scenarios include tuning slow queries and translating queries between PostgreSQL, MySQL, and SQL Server

Quick Start

Explain the best-practice approach to writing and optimizing the provided SQL query.

Frequently Asked Questions about sql-assistant

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow SQL queries and analyze execution plans?▼

To optimize slow SQL queries, you analyze execution plans to identify bottlenecks, apply indexing strategies, and follow performance tuning recommendations to resolve execution inefficiencies across relational databases.

Can I translate SQL queries between PostgreSQL, MySQL, and SQL Server?▼

Yes, you can translate SQL queries between PostgreSQL, MySQL, and SQL Server through dialect-aware guidance that checks cross-database compatibility and adjusts syntax to match the targeted relational database dialect.

What is the best way to write SQL queries following best practices?▼

Writing SQL queries following best practices involves using guided code writing recommendations that enforce quality standards, prevent common structural issues, and ensure dialect-aware syntax across different relational databases.

How do I resolve SQL query quality issues and indexing problems?▼

Resolving SQL query quality issues requires identifying performance degradation through plan evaluation, then applying targeted indexing suggestions and optimization recommendations to deliver actionable improvements for relational databases.

Does SQL query optimization support common SQL tooling and different dialects?▼

SQL query optimization supports common SQL tooling integration and provides dialect-aware guidance across multiple SQL dialects, ensuring actionable improvements apply broadly to various relational database environments.

Related Skills

Explore More Software Engineering Skills→
Axel-DaMageAxel-DaMage
2

sql-pro

Optimize SQL queries and design database schemas with indexing strategies.

Community
Advanced
cenjiecenjie

database-query-optimization

Analyze EXPLAIN ANALYZE diagnostics and apply indexing to optimize database queries.

Community
Advanced
saschadudkin-sketchsaschadudkin-sketch

sql-pro

Optimize SQL queries and design efficient database schemas.

Community
Advanced
neogenzneogenz
4

workflow-clean-code-angular

Automate Angular 21 clean-code workflows to detect and fix anti-patterns.

Community
Advanced