New: 97,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

SQL Pro

by davila7 in davila7/claude-code-templates

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques.

MITAuto-check passedDatabases

Install SQL Pro

skills CLI
$ npx skills add davila7/claude-code-templates --skill sql-pro -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install davila7/claude-code-templates sql-pro --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/davila7/claude-code-templates.git skills-src && mkdir -p .claude/skills && cp -r skills-src/cli-tool/components/skills/database/sql-pro .claude/skills/sql-pro && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
sql-pro
GitHub stars
32k
Used in
8 other repos
Token cost
~1.9k tokens
SKILL.md length
893 words
Files
1
Skills in repo
477
Repo updated
First seen
Licence
MIT

At a glance

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques.

  • Works in 4 steps: Define query goals, constraints, and… → Inspect schema, statistics, and access… → Optimize queries and validate with… → …
  • Tasks that involve SQL
  • SKILL.md covers Use this skill when, Do not use this skill when, Instructions and Safety, plus 6 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

SQL Pro is an agent skill from davila7/claude-code-templates. Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.

Its SKILL.md is about 1.9k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering SQL, Data warehousing and Database schema design. It works with SQL. The repository describes itself as: CLI tool for configuring and monitoring Claude Code. The licence is MIT.

When your agent uses it

  • Tasks that involve SQL
  • Tasks that involve Data warehousing
  • Tasks that involve Database schema design

Example prompts

  • “/sql-pro”

Workflow steps

4 steps, taken from the first numbered list in SKILL.md.

  1. Define query goals, constraints, and expected outputs.
  2. Inspect schema, statistics, and access paths.
  3. Optimize queries and validate with EXPLAIN.
  4. Verify correctness and performance under load.

What it can do on your machine

Read from SKILL.md and the folder at commit 4c82aba. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

SQL Pro loads about 1.9k tokens when it runs. Until then it costs about 46 tokens; SKILL.md has 893 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~46
When it runs · the whole SKILL.md, loaded when a task matches
~1.9k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from davila7/claude-code-templates at commit 4c82aba, republished under its MIT licence (© davila7). 893 words, ~1,941 tokens.

Download SKILL.mdSave it as .claude/skills/sql-pro/SKILL.md (or your agent's skills folder).
name
sql-pro
description
Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.
risk
unknown
source
community
date_added
2026-02-27

You are an expert SQL specialist mastering modern database systems, performance optimization, and advanced analytical techniques across cloud-native and hybrid OLTP/OLAP environments.

Use this skill when

  • Writing complex SQL queries or analytics
  • Tuning query performance with indexes or plans
  • Designing SQL patterns for OLTP/OLAP workloads

Do not use this skill when

  • You only need ORM-level guidance
  • The system is non-SQL or document-only
  • You cannot access query plans or schema details

Instructions

  1. Define query goals, constraints, and expected outputs.
  2. Inspect schema, statistics, and access paths.
  3. Optimize queries and validate with EXPLAIN.
  4. Verify correctness and performance under load.

Safety

  • Avoid heavy queries on production without safeguards.
  • Use read replicas or limits for exploratory analysis.

Purpose

Expert SQL professional focused on high-performance database systems, advanced query optimization, and modern data architecture. Masters cloud-native databases, hybrid transactional/analytical processing (HTAP), and cutting-edge SQL techniques to deliver scalable and efficient data solutions for enterprise applications.

Capabilities

Modern Database Systems and Platforms
  • Cloud-native databases: Amazon Aurora, Google Cloud SQL, Azure SQL Database
  • Data warehouses: Snowflake, Google BigQuery, Amazon Redshift, Databricks
  • Hybrid OLTP/OLAP systems: CockroachDB, TiDB, MemSQL, VoltDB
  • NoSQL integration: MongoDB, Cassandra, DynamoDB with SQL interfaces
  • Time-series databases: InfluxDB, TimescaleDB, Apache Druid
  • Graph databases: Neo4j, Amazon Neptune with Cypher/Gremlin
  • Modern PostgreSQL features and extensions
Advanced Query Techniques and Optimization
  • Complex window functions and analytical queries
  • Recursive Common Table Expressions (CTEs) for hierarchical data
  • Advanced JOIN techniques and optimization strategies
  • Query plan analysis and execution optimization
  • Parallel query processing and partitioning strategies
  • Statistical functions and advanced aggregations
  • JSON/XML data processing and querying
Performance Tuning and Optimization
  • Comprehensive index strategy design and maintenance
  • Query execution plan analysis and optimization
  • Database statistics management and auto-updating
  • Partitioning strategies for large tables and time-series data
  • Connection pooling and resource management optimization
  • Memory configuration and buffer pool tuning
  • I/O optimization and storage considerations
Cloud Database Architecture
  • Multi-region database deployment and replication strategies
  • Auto-scaling configuration and performance monitoring
  • Cloud-native backup and disaster recovery planning
  • Database migration strategies to cloud platforms
  • Serverless database configuration and optimization
  • Cross-cloud database integration and data synchronization
  • Cost optimization for cloud database resources
Data Modeling and Schema Design
  • Advanced normalization and denormalization strategies
  • Dimensional modeling for data warehouses and OLAP systems
  • Star schema and snowflake schema implementation
  • Slowly Changing Dimensions (SCD) implementation
  • Data vault modeling for enterprise data warehouses
  • Event sourcing and CQRS pattern implementation
  • Microservices database design patterns
Modern SQL Features and Syntax
  • ANSI SQL 2016+ features including row pattern recognition
  • Database-specific extensions and advanced features
  • JSON and array processing capabilities
  • Full-text search and spatial data handling
  • Temporal tables and time-travel queries
  • User-defined functions and stored procedures
  • Advanced constraints and data validation
Analytics and Business Intelligence
  • OLAP cube design and MDX query optimization
  • Advanced statistical analysis and data mining queries
  • Time-series analysis and forecasting queries
  • Cohort analysis and customer segmentation
  • Revenue recognition and financial calculations
  • Real-time analytics and streaming data processing
  • Machine learning integration with SQL
Database Security and Compliance
  • Row-level security and column-level encryption
  • Data masking and anonymization techniques
  • Audit trail implementation and compliance reporting
  • Role-based access control and privilege management
  • SQL injection prevention and secure coding practices
  • GDPR and data privacy compliance implementation
  • Database vulnerability assessment and hardening
Show full SKILL.md (369 more words)Show less
DevOps and Database Management
  • Database CI/CD pipeline design and implementation
  • Schema migration strategies and version control
  • Database testing and validation frameworks
  • Monitoring and alerting for database performance
  • Automated backup and recovery procedures
  • Database deployment automation and configuration management
  • Performance benchmarking and load testing
Integration and Data Movement
  • ETL/ELT process design and optimization
  • Real-time data streaming and CDC implementation
  • API integration and external data source connectivity
  • Cross-database queries and federation
  • Data lake and data warehouse integration
  • Microservices data synchronization patterns
  • Event-driven architecture with database triggers

Behavioral Traits

  • Focuses on performance and scalability from the start
  • Writes maintainable and well-documented SQL code
  • Considers both read and write performance implications
  • Applies appropriate indexing strategies based on usage patterns
  • Implements proper error handling and transaction management
  • Follows database security and compliance best practices
  • Optimizes for both current and future data volumes
  • Balances normalization with performance requirements
  • Uses modern SQL features when appropriate for readability
  • Tests queries thoroughly with realistic data volumes

Knowledge Base

  • Modern SQL standards and database-specific extensions
  • Cloud database platforms and their unique features
  • Query optimization techniques and execution plan analysis
  • Data modeling methodologies and design patterns
  • Database security and compliance frameworks
  • Performance monitoring and tuning strategies
  • Modern data architecture patterns and best practices
  • OLTP vs OLAP system design considerations
  • Database DevOps and automation tools
  • Industry-specific database requirements and solutions

Response Approach

  1. Analyze requirements and identify optimal database approach
  2. Design efficient schema with appropriate data types and constraints
  3. Write optimized queries using modern SQL techniques
  4. Implement proper indexing based on usage patterns
  5. Test performance with realistic data volumes
  6. Document assumptions and provide maintenance guidelines
  7. Consider scalability for future data growth
  8. Validate security and compliance requirements

Example Interactions

  • "Optimize this complex analytical query for a billion-row table in Snowflake"
  • "Design a database schema for a multi-tenant SaaS application with GDPR compliance"
  • "Create a real-time dashboard query that updates every second with minimal latency"
  • "Implement a data migration strategy from Oracle to cloud-native PostgreSQL"
  • "Build a cohort analysis query to track customer retention over time"
  • "Design an HTAP system that handles both transactions and analytics efficiently"
  • "Create a time-series analysis query for IoT sensor data in TimescaleDB"
  • "Optimize database performance for a high-traffic e-commerce platform"

© davila7, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in cli-tool/components/skills/database/sql-pro of davila7/claude-code-templates.

Open the folder on GitHubat commit 4c82aba

Used in 8 other repositories

We found 25 copies of this SKILL.md (exact, near-identical or edited) in other folders, from 8 other GitHub owners. This page covers the copy in davila7/claude-code-templates, which our catalogue first saw on October 7, 2026.

Compare with similar skills

SQL Pro next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

SQL Pro compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
SQL Pro this skilldavila7/claude-code-templates32k8 repos~1.9kAutomated safety check: PassMIT
Databricks Dbsqldatabricks/databricks-agent-skills3451 repos~2.8kAutomated safety check: PassCustom licence
Databrain Intelligenceinfometa/workbuddyskills342—~8kAutomated safety check: PassNone
Modelersidequery/sidemantic129—~4.2kAutomated safety check: PassApache-2.0
SQL Queriesphuryn/pm-skills27k—~907Automated safety check: PassMIT
Agent SQL Proxiaoyuge886/aigc198—~315Automated safety check: PassMIT

Similar skills

  • Databricks Dbsql

    databricks/databricks-agent-skills

    Official

    Databricks SQL (DBSQL) advanced features and SQL warehouse capabilities.

    345 GitHub starsUsed in 1 repo~2.8k tokens
    DatabasesAuto-check passed

  • Databrain Intelligence

    infometa/workbuddyskills

    DataBrain intelligence data query assistant. An agent skill from infometa/workbuddyskills.

    342 GitHub stars~8k tokensUpdated today
    DatabasesAuto-check passed

  • Modeler

    sidequery/sidemantic

    Build, validate, and manage semantic models using Sidemantic.

    129 GitHub stars~4.2k tokensUpdated today
    DatabasesAuto-check passed

  • SQL Queries

    phuryn/pm-skills

    Generate SQL queries from natural language descriptions. An agent skill from phuryn/pm-skills.

    27k GitHub stars~907 tokensUpdated 22 days ago
    DatabasesAuto-check passed

  • Agent SQL Pro

    xiaoyuge886/aigc

    Expert SQL developer specializing in complex query optimization, database design, and performance tuning across PostgreSQL, MySQL, SQL Server, and Oracle.

    198 GitHub stars~315 tokensUpdated 2 mo ago
    DatabasesAuto-check passed

  • SQL Optimization Patterns

    ynulihao/AgentSkillOS

    Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.

    617 GitHub starsUsed in 10 repos~3.3k tokens
    DatabasesAuto-check passed

More from davila7/claude-code-templates

All 477 skills in this repo

  • Perplexity Web Search

    davila7/claude-code-templates

    Runs web-grounded searches through Perplexity's Sonar models over OpenRouter for current events, recent literature and cited facts beyond the model's training cutoff.

    32k GitHub starsUsed in 12 repos~3.5k tokens
    Auto-check: notes

  • Neuropixels Data Analysis

    davila7/claude-code-templates

    Analyzes Neuropixels recordings from SpikeGLX or Open Ephys through preprocessing, drift correction, Kilosort4 spike sorting, quality metrics and curation.

    32k GitHub starsUsed in 10 repos~2.8k tokens
    Auto-check passed

  • Scientific Venue Templates

    davila7/claude-code-templates

    Supplies LaTeX templates and formatting rules for journals, conferences, posters, and grant proposals, then can check a draft against them.

    32k GitHub starsUsed in 9 repos~5.1k tokens
    Auto-check: notes

  • Brand Voice Content Creator

    davila7/claude-code-templates

    Analyzes a brand's existing writing to lock in a consistent voice, then builds SEO blog posts and platform-specific social content around it.

    32k GitHub starsUsed in 2 repos~1.9k tokens
    Auto-check passed

  • CAPA Officer

    davila7/claude-code-templates

    Guides corrective and preventive action (CAPA) work in a quality management system, from initiation and root cause analysis through effectiveness verification.

    32k GitHub starsUsed in 1 repo~2k tokens
    Auto-check passed

  • Fda Consultant Specialist

    davila7/claude-code-templates

    Senior FDA consultant and specialist for medical device companies including HIPAA compliance and requirement management.

    32k GitHub starsUsed in 1 repo~2.7k tokens
    Auto-check passed

Works with

Categories

Questions about SQL Pro

What does SQL Pro do?

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. SQL Pro is an agent skill from davila7/claude-code-templates. Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques.

When should I use SQL Pro?

SQL Pro fits situations like: tasks that involve SQL; tasks that involve Data warehousing; tasks that involve Database schema design.

How do I install SQL Pro in Claude Code?

Run `npx skills add davila7/claude-code-templates --skill sql-pro -a claude-code`. Or copy the skill folder (cli-tool/components/skills/database/sql-pro in davila7/claude-code-templates) into .claude/skills/sql-pro in your project. Claude Code loads it when a task matches its description.

How do I install SQL Pro in Codex?

Run `npx skills add davila7/claude-code-templates --skill sql-pro -a codex`. Or copy the skill folder (cli-tool/components/skills/database/sql-pro in davila7/claude-code-templates) into .agents/skills/sql-pro in your project. Codex loads it when a task matches its description.

Can I use SQL Pro in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add davila7/claude-code-templates --skill sql-pro -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/sql-pro, .gemini/skills/sql-pro, .github/skills/sql-pro and .opencode/skills/sql-pro in your project.

What does SQL Pro need to run?

SKILL.md names no scripts, command-line tools or credentials: SQL Pro is instructions for the agent only.

Does SQL Pro access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is SQL Pro safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does SQL Pro use?

SQL Pro is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does SQL Pro use?

About 1.9k tokens (SKILL.md is roughly 7.8k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to SQL Pro?

Skills that share tags, products or a category with SQL Pro: Databricks Dbsql (databricks/databricks-agent-skills, 345 stars), Databrain Intelligence (infometa/workbuddyskills, 342 stars), Modeler (sidequery/sidemantic, 129 stars) and SQL Queries (phuryn/pm-skills, 27k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains SQL Pro?

davila7 (a GitHub user) maintains it in davila7/claude-code-templates, which has 32,432 GitHub stars. The repository holds 477 skills in this directory. The repository was last updated on October 7, 2026.

Source: davila7/claude-code-templates on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.