AgentSkillsCN

databases-sql

SQL数据库查询、优化与数据分析管理

SKILL.md
--- frontmatter
name: databases-sql
description: SQL database querying, optimization, and data management for analytics
version: "2.0.0"
sasmp_version: "2.0.0"
bonded_agent: 02-sql-databases-expert
bond_type: PRIMARY_BOND

# Skill Configuration
config:
  atomic: true
  retry_enabled: true
  max_retries: 3
  backoff_strategy: exponential
  query_timeout: 120

# Parameter Validation
parameters:
  database_type:
    type: string
    required: true
    enum: [postgresql, mysql, sqlserver, sqlite, bigquery, snowflake]
    default: postgresql
  skill_level:
    type: string
    required: true
    enum: [beginner, intermediate, advanced, expert]
    default: beginner
  focus_area:
    type: string
    required: false
    enum: [queries, optimization, design, warehousing, all]
    default: all

# Observability
observability:
  logging_level: info
  metrics: [query_count, execution_time, optimization_score]
  query_logging: true

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 TypeCauseRecovery
Syntax errorInvalid SQLValidate query syntax before execution
TimeoutLong-running queryAdd indexes, optimize query
Connection failedNetwork/auth issueRetry with exponential backoff
Permission deniedAccess rightsRequest appropriate permissions
DeadlockConcurrent transactionsRetry transaction

Related Skills

  • •foundations (for data concepts)
  • •programming (for SQL with Python/R)
  • •advanced (for big data processing)