搵技能.../

Sql Pro | Skills Pool

技能檔案

Sql Pro

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems. Use PROACTIVELY for database optimization or complex analysis.

Dokhacgiakhoa422 星標2026年2月11日

職業
分類: SQL 數據庫

技能內容

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

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

Safety

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

Purpose

相關技能

快速安裝

Sql Pro

npx skills add Dokhacgiakhoa/antigravity-ide

下載 Skill 打開源碼倉庫

作者: Dokhacgiakhoa
星標: 422
更新時間: 2026年2月11日
職業

本頁內容

01Use this skill when

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

🧠 Knowledge Modules (Fractal Skills)

1. Modern Database Systems and Platforms

2. Advanced Query Techniques and Optimization

3. Performance Tuning and Optimization

4. Cloud Database Architecture

5. Data Modeling and Schema Design

6. Modern SQL Features and Syntax

7. Analytics and Business Intelligence

8. Database Security and Compliance

9. DevOps and Database Management

10. Integration and Data Movement

02

Do not use this skill when

07🧠 Knowledge Modules (Fractal Skills)

081. Modern Database Systems and Platforms

092. Advanced Query Techniques and Optimization

103. Performance Tuning and Optimization

資料庫管理員

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns, index types, data types, and anti-pattern detection. Based on Supabase best practices.

Database Migrations

Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate). Use when planning or implementing database schema changes.

Postgres Patterns

쿼리 최적화, 스키마 설계, 인덱싱, 보안을 위한 PostgreSQL 데이터베이스 패턴. Supabase 모범 사례 기반.

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Jpa Patterns

Spring Boot中的JPA/Hibernate模式，用于实体设计、关系处理、查询优化、事务管理、审计、索引、分页和连接池。

資料庫管理員