skills.rest
rar-file
rar-fileCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

SQL Expert

Write efficient SQL queries and design normalized schemas for PostgreSQL, MySQL, SQLite, and SQL Server.

42|1|Updated Mar 17, 2026
Search Tags:#queries#sql#indexes#query-optimization#data-modeling#database-design#explain-plan
One-click install
npx skills add https://github.com/rar-file/surf --skill sql-expert-rar-file
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: SQL Expert
Source: https://github.com/rar-file/surf/tree/main/skills/sql_expert
Command: npx skills add https://github.com/rar-file/surf --skill sql-expert-rar-file

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps developers write efficient SQL, optimize queries, and design robust database schemas.

Core Features & Use Cases

  • Query optimization: build fast, readable queries with proper joins, indexes, and window functions.
  • Schema design: create normalized schemas with clear relationships and data integrity.
  • Explain plans & migrations: analyze execution plans, suggest indexing strategies, and plan zero-downtime migrations.

Quick Start

Ask me to generate an optimized SQL query or propose a normalized schema for your dataset.

Frequently Asked Questions about SQL Expert

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

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

Optimize slow SQL queries by analyzing execution plans to identify bottlenecks, then applying proper joins, window functions, and indexing strategies to improve query performance and readability.

What's the best way to design a normalized database schema with data integrity?▼

Design a normalized database schema by creating clear relationships between tables, enforcing data integrity constraints, and structuring data models to support efficient real-world data tasks.

Does this SQL query optimization approach work with PostgreSQL and MySQL?▼

Yes, this SQL query optimization approach works with PostgreSQL, MySQL, SQLite, and SQL Server workloads, supporting performance tuning, indexing strategies, and schema design across these database platforms.

How do I plan zero-downtime database migrations safely?▼

Plan zero-downtime database migrations safely by analyzing explain plans, enforcing best practices like parameterized queries, and applying safe migration strategies to maintain database availability.

When should I add indexes to improve database performance?▼

Add indexes to improve database performance when execution plans reveal slow scans or missing access paths, using indexing strategies that support your specific query patterns and database design.

Related Skills

Explore More Software Engineering Skills→
yu13130122297yu13130122297

scout

Identify uncertainties in research framing, datasets, metrics, and baselines.

Community
Intermediate
amo-tech-aiamo-tech-ai

performance-optimization

Optimize React SPAs, Supabase queries, and edge functions for performance.

Community
Advanced
pedronauckpedronauck
567

postgres-drizzle

Define PostgreSQL schemas, queries, and migrations with Drizzle ORM.

Community
Intermediate
jabrenajabrena
423

705-technologies-nosql-mongodb

Optimize MongoDB queries and design NoSQL schemas with JSON Schema validation.

Community
Advanced