skills.rest
thechandanbhagat
thechandanbhagatCOMMUNITY
Explore all skills by this author →
Website𝕏@chandangbhagatGitHub

sql

Write and optimize SQL queries for relational databases.

8|Updated Jan 22, 2026
Search Tags:#performance#SQL#database#optimization#queries#schema-design#write
One-click install
npx skills add https://github.com/thechandanbhagat/claude-skills --skill sql-thechandanbhagat
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql
Source: https://github.com/thechandanbhagat/claude-skills/tree/main/skills/sql
Command: npx skills add https://github.com/thechandanbhagat/claude-skills --skill sql-thechandanbhagat

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Write SQL queries accurately and optimize performance to simplify data retrieval and reporting.

Core Features & Use Cases

  • Query Writing: Create SELECT/INSERT/UPDATE/DELETE statements with joins, subqueries, and aggregations.
  • Optimization & Tuning: Analyze execution plans, index strategies, and query refactoring for speed.
  • Use Case: Build fast dashboards and reports from large relational datasets by writing efficient queries and choosing appropriate schemas.

Quick Start

Start with a simple SELECT on a sample table, then progressively optimize queries and design schemas for common analytics tasks.

Frequently Asked Questions about sql

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

FAQPage Schema
How do I write SQL queries for data retrieval and reporting?▼

SQL queries for data retrieval are written using SELECT, INSERT, UPDATE, and DELETE statements. You can construct these statements with joins, subqueries, and aggregations to accurately extract and transform data from relational databases for reporting.

What is the best way to optimize SQL query performance for large datasets?▼

The best way to optimize SQL query performance is by analyzing execution plans and refactoring queries. You can apply index strategies to tune speed, ensuring efficient data retrieval from large relational datasets for fast dashboards and reports.

Can I use this approach to design database schemas for analytics tasks?▼

Yes, you can design database schemas for analytics tasks. Choosing appropriate schemas alongside writing optimized queries allows you to effectively structure relational data for varied data scenarios and reporting needs.

Do I need specific database knowledge to tune query performance?▼

You need foundational knowledge of relational databases to tune query performance. Understanding execution plans and index strategies helps you refactor queries across multiple RDBMS platforms to achieve faster data retrieval.

Why does my SQL query run slowly on large relational datasets?▼

Your SQL query runs slowly due to unoptimized execution plans or missing index strategies. You can refactor the query and apply performance tuning techniques to improve speed and simplify data retrieval from large datasets.

Related Skills

Explore More Data & Analytics Skills→
D26FORWARDD26FORWARD

schema-exploration

List database tables, inspect schemas, and map foreign key join paths.

Community
Intermediate
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
voidrotvoidrot

postgres-patterns

Analyze and optimize PostgreSQL queries using EXPLAIN ANALYZE and indexing strategies.

Community
Advanced
sourcegraphsourcegraph
16

bigquery

Run BigQuery SQL queries and export results using the bq CLI.

Official
Advanced