ReddRadar
Agent skill
databases-sql
SQL database querying, optimization, and data management for analytics
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/data/databases-sql
SKILL.md
Databases & SQL Skill
Overview
Master SQL and database concepts essential for data analysts, from basic queries to advanced optimization and data warehousing.
Core Topics
SQL Fundamentals
- SELECT, FROM, WHERE, ORDER BY
- JOINs (INNER, LEFT, RIGHT, FULL)
- GROUP BY and aggregate functions
- Subqueries and CTEs
Advanced SQL
- Window functions (ROW_NUMBER, RANK, LAG, LEAD)
- Recursive queries
- Query optimization and execution plans
- Index strategies
Database Concepts
- Relational database design principles
- Normalization and denormalization
- Data warehousing concepts (star schema, snowflake)
- ETL processes
Popular Platforms
- PostgreSQL
- MySQL
- SQL Server
- BigQuery, Redshift, Snowflake
Learning Objectives
- Write efficient SQL queries for data extraction
- Understand database design and optimization
- Work with cloud data warehouses
- Implement ETL processes for analytics pipelines
Error Handling
| Error Type | Cause | Recovery |
|---|---|---|
| Syntax error | Invalid SQL | Validate query syntax before execution |
| Timeout | Long-running query | Add indexes, optimize query |
| Connection failed | Network/auth issue | Retry with exponential backoff |
| Permission denied | Access rights | Request appropriate permissions |
| Deadlock | Concurrent transactions | Retry transaction |
Related Skills
- foundations (for data concepts)
- programming (for SQL with Python/R)
- advanced (for big data processing)
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?