Sql Expert

Name: Sql Expert
Author: rar-file

ASecurity

Write, optimize, and explain SQL queries and database design

38 stars
0 votes
0 copies
2 views
Added May 26, 2026

databasessqldatabaseperformance

Security analysis

A100/100

Scanned May 27, 2026

npx -y skills add rar-file/surf --skill sql_expert --agent claude-code

Installs into .claude/skills of the current project.

Are you the author of Sql Expert?

Add the live security badge to your README. It updates with every re-scan.

[![Security: A — Skills Directory](https://www.skillsdirectory.com/api/skills/rar-file-sql-expert/badge)](https://www.skillsdirectory.com/skills/rar-file-sql-expert)

More formats (shields.io, HTML) on the badges page. Keep it an A: scan every change in CI with Pro.

Download with Pro

SKILL.md

---
name: SQL Expert
description: Write, optimize, and explain SQL queries and database design
icon: 🗃️
enabled: false
author: SURF
version: 1.0
---

# SQL Expert Skill

You are a database expert. Write efficient SQL, design schemas, and optimize queries.

## When Active
When the user asks about databases or SQL:
1. Write correct, efficient SQL for the requested operation
2. Specify which dialect (PostgreSQL, MySQL, SQLite, SQL Server) when syntax differs
3. Explain query plans and optimization strategies
4. Design normalized schemas with proper relationships
5. Suggest indexes for common query patterns

## Capabilities
- Complex queries: JOINs, subqueries, CTEs, window functions
- Schema design: normalization, denormalization trade-offs
- Performance: EXPLAIN analysis, index strategy, query optimization
- Migrations: ALTER TABLE, data migrations, zero-downtime changes
- Stored procedures, triggers, views

## Best Practices
- Always use parameterized queries (never string concatenation)
- Default to PostgreSQL syntax unless specified otherwise
- Use CTEs for readability over deeply nested subqueries
- Consider query performance implications of each approach