{"id":"f163f25d-2e30-4b93-aa03-2d79754487cb","shortId":"q9AyLs","kind":"skill","title":"sql-pro","tagline":"Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.","description":"You are an expert SQL specialist mastering modern database systems, performance optimization, and advanced analytical techniques across cloud-native and hybrid OLTP/OLAP environments.\n\n## Use this skill when\n\n- Writing complex SQL queries or analytics\n- Tuning query performance with indexes or plans\n- Designing SQL patterns for OLTP/OLAP workloads\n\n## Do not use this skill when\n\n- You only need ORM-level guidance\n- The system is non-SQL or document-only\n- You cannot access query plans or schema details\n\n## Instructions\n\n1. Define query goals, constraints, and expected outputs.\n2. Inspect schema, statistics, and access paths.\n3. Optimize queries and validate with EXPLAIN.\n4. Verify correctness and performance under load.\n\n## Safety\n\n- Avoid heavy queries on production without safeguards.\n- Use read replicas or limits for exploratory analysis.\n\n## Purpose\nExpert 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.\n\n## Capabilities\n\n### Modern Database Systems and Platforms\n- Cloud-native databases: Amazon Aurora, Google Cloud SQL, Azure SQL Database\n- Data warehouses: Snowflake, Google BigQuery, Amazon Redshift, Databricks\n- Hybrid OLTP/OLAP systems: CockroachDB, TiDB, MemSQL, VoltDB\n- NoSQL integration: MongoDB, Cassandra, DynamoDB with SQL interfaces\n- Time-series databases: InfluxDB, TimescaleDB, Apache Druid\n- Graph databases: Neo4j, Amazon Neptune with Cypher/Gremlin\n- Modern PostgreSQL features and extensions\n\n### Advanced Query Techniques and Optimization\n- Complex window functions and analytical queries\n- Recursive Common Table Expressions (CTEs) for hierarchical data\n- Advanced JOIN techniques and optimization strategies\n- Query plan analysis and execution optimization\n- Parallel query processing and partitioning strategies\n- Statistical functions and advanced aggregations\n- JSON/XML data processing and querying\n\n### Performance Tuning and Optimization\n- Comprehensive index strategy design and maintenance\n- Query execution plan analysis and optimization\n- Database statistics management and auto-updating\n- Partitioning strategies for large tables and time-series data\n- Connection pooling and resource management optimization\n- Memory configuration and buffer pool tuning\n- I/O optimization and storage considerations\n\n### Cloud Database Architecture\n- Multi-region database deployment and replication strategies\n- Auto-scaling configuration and performance monitoring\n- Cloud-native backup and disaster recovery planning\n- Database migration strategies to cloud platforms\n- Serverless database configuration and optimization\n- Cross-cloud database integration and data synchronization\n- Cost optimization for cloud database resources\n\n### Data Modeling and Schema Design\n- Advanced normalization and denormalization strategies\n- Dimensional modeling for data warehouses and OLAP systems\n- Star schema and snowflake schema implementation\n- Slowly Changing Dimensions (SCD) implementation\n- Data vault modeling for enterprise data warehouses\n- Event sourcing and CQRS pattern implementation\n- Microservices database design patterns\n\n### Modern SQL Features and Syntax\n- ANSI SQL 2016+ features including row pattern recognition\n- Database-specific extensions and advanced features\n- JSON and array processing capabilities\n- Full-text search and spatial data handling\n- Temporal tables and time-travel queries\n- User-defined functions and stored procedures\n- Advanced constraints and data validation\n\n### Analytics and Business Intelligence\n- OLAP cube design and MDX query optimization\n- Advanced statistical analysis and data mining queries\n- Time-series analysis and forecasting queries\n- Cohort analysis and customer segmentation\n- Revenue recognition and financial calculations\n- Real-time analytics and streaming data processing\n- Machine learning integration with SQL\n\n### Database Security and Compliance\n- Row-level security and column-level encryption\n- Data masking and anonymization techniques\n- Audit trail implementation and compliance reporting\n- Role-based access control and privilege management\n- SQL injection prevention and secure coding practices\n- GDPR and data privacy compliance implementation\n- Database vulnerability assessment and hardening\n\n### DevOps and Database Management\n- Database CI/CD pipeline design and implementation\n- Schema migration strategies and version control\n- Database testing and validation frameworks\n- Monitoring and alerting for database performance\n- Automated backup and recovery procedures\n- Database deployment automation and configuration management\n- Performance benchmarking and load testing\n\n### Integration and Data Movement\n- ETL/ELT process design and optimization\n- Real-time data streaming and CDC implementation\n- API integration and external data source connectivity\n- Cross-database queries and federation\n- Data lake and data warehouse integration\n- Microservices data synchronization patterns\n- Event-driven architecture with database triggers\n\n## Behavioral Traits\n- Focuses on performance and scalability from the start\n- Writes maintainable and well-documented SQL code\n- Considers both read and write performance implications\n- Applies appropriate indexing strategies based on usage patterns\n- Implements proper error handling and transaction management\n- Follows database security and compliance best practices\n- Optimizes for both current and future data volumes\n- Balances normalization with performance requirements\n- Uses modern SQL features when appropriate for readability\n- Tests queries thoroughly with realistic data volumes\n\n## Knowledge Base\n- Modern SQL standards and database-specific extensions\n- Cloud database platforms and their unique features\n- Query optimization techniques and execution plan analysis\n- Data modeling methodologies and design patterns\n- Database security and compliance frameworks\n- Performance monitoring and tuning strategies\n- Modern data architecture patterns and best practices\n- OLTP vs OLAP system design considerations\n- Database DevOps and automation tools\n- Industry-specific database requirements and solutions\n\n## Response Approach\n1. **Analyze requirements** and identify optimal database approach\n2. **Design efficient schema** with appropriate data types and constraints\n3. **Write optimized queries** using modern SQL techniques\n4. **Implement proper indexing** based on usage patterns\n5. **Test performance** with realistic data volumes\n6. **Document assumptions** and provide maintenance guidelines\n7. **Consider scalability** for future data growth\n8. **Validate security** and compliance requirements\n\n## Example Interactions\n- \"Optimize this complex analytical query for a billion-row table in Snowflake\"\n- \"Design a database schema for a multi-tenant SaaS application with GDPR compliance\"\n- \"Create a real-time dashboard query that updates every second with minimal latency\"\n- \"Implement a data migration strategy from Oracle to cloud-native PostgreSQL\"\n- \"Build a cohort analysis query to track customer retention over time\"\n- \"Design an HTAP system that handles both transactions and analytics efficiently\"\n- \"Create a time-series analysis query for IoT sensor data in TimescaleDB\"\n- \"Optimize database performance for a high-traffic e-commerce platform\"\n\n## Limitations\n- Use this skill only when the task clearly matches the scope described above.\n- Do not treat the output as a substitute for environment-specific validation, testing, or expert review.\n- Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.","tags":["sql","pro","antigravity","awesome","skills","sickn33","agent-skills","agentic-skills","ai-agent-skills","ai-agents","ai-coding","ai-workflows"],"capabilities":["skill","source-sickn33","skill-sql-pro","topic-agent-skills","topic-agentic-skills","topic-ai-agent-skills","topic-ai-agents","topic-ai-coding","topic-ai-workflows","topic-antigravity","topic-antigravity-skills","topic-claude-code","topic-claude-code-skills","topic-codex-cli","topic-codex-skills"],"categories":["antigravity-awesome-skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/sickn33/antigravity-awesome-skills/sql-pro","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add sickn33/antigravity-awesome-skills","source_repo":"https://github.com/sickn33/antigravity-awesome-skills","install_from":"skills.sh"}},"qualityScore":"0.700","qualityRationale":"deterministic score 0.70 from registry signals: · indexed on github topic:agent-skills · 34515 github stars · SKILL.md body (7,812 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-04-22T12:51:49.367Z","embedding":null,"createdAt":"2026-04-18T21:45:21.068Z","updatedAt":"2026-04-22T12:51:49.367Z","lastSeenAt":"2026-04-22T12:51:49.367Z","tsv":"'1':107,832 '2':115,840 '2016':457 '3':122,850 '4':129,858 '5':866 '6':873 '7':880 '8':887 'access':100,120,577 'across':44 'advanc':15,41,163,256,275,296,409,468,497,513 'aggreg':297 'alert':623 'amazon':205,218,247 'analysi':151,283,316,515,523,528,788,951,975 'analyt':26,42,61,265,502,540,898,968 'analyz':833 'anonym':566 'ansi':455 'apach':242 'api':660 'appli':715 'applic':194,918 'approach':831,839 'appropri':716,755,845 'architectur':169,355,686,807 'array':472 'ask':1028 'assess':597 'assumpt':875 'audit':568 'aurora':206 'auto':324,365 'auto-sc':364 'auto-upd':323 'autom':627,634,821 'avoid':137 'azur':210 'backup':374,628 'balanc':745 'base':576,719,766,862 'behavior':690 'benchmark':639 'best':735,810 'bigqueri':217 'billion':903 'billion-row':902 'boundari':1036 'buffer':345 'build':948 'busi':504 'calcul':536 'cannot':99 'capabl':195,474 'cassandra':231 'cdc':658 'chang':429 'ci/cd':605 'clarif':1030 'clear':1003 'cloud':9,46,172,202,208,353,372,383,392,401,775,945 'cloud-nat':8,45,171,201,371,944 'cockroachdb':224 'code':587,707 'cohort':527,950 'column':560 'column-level':559 'commerc':993 'common':268 'complex':57,261,897 'complianc':553,572,593,734,798,891,921 'comprehens':307 'configur':343,367,387,636 'connect':336,666 'consid':708,881 'consider':352,817 'constraint':111,498,849 'control':578,615 'correct':131 'cost':398 'cqrs':443 'creat':922,970 'criteria':1039 'cross':391,668 'cross-cloud':390 'cross-databas':667 'ctes':271 'cube':507 'current':740 'custom':530,955 'cut':181 'cutting-edg':180 'cypher/gremlin':250 'dashboard':927 'data':22,168,190,213,274,299,335,396,404,417,433,438,481,500,517,543,563,591,645,655,664,673,676,680,743,763,789,806,846,871,885,938,980 'databas':11,36,161,174,197,204,212,239,245,319,354,359,379,386,393,402,447,464,550,595,602,604,616,625,632,669,688,731,772,776,795,818,826,838,910,984 'database-specif':463,771 'databrick':220 'defin':108,492 'deliv':186 'denorm':412 'deploy':360,633 'describ':1007 'design':69,310,408,448,508,607,649,793,816,841,908,959 'detail':105 'devop':600,819 'dimens':430 'dimension':414 'disast':376 'document':96,705,874 'document-on':95 'driven':685 'druid':243 'dynamodb':232 'e':992 'e-commerc':991 'edg':182 'effici':189,842,969 'encrypt':562 'enterpris':193,437 'environ':51,1019 'environment-specif':1018 'error':725 'etl/elt':647 'event':440,684 'event-driven':683 'everi':931 'exampl':893 'execut':285,314,786 'expect':113 'expert':18,31,153,1024 'explain':128 'exploratori':150 'express':270 'extens':255,466,774 'extern':663 'featur':253,452,458,469,753,781 'feder':672 'financi':535 'focus':156,692 'follow':730 'forecast':525 'framework':620,799 'full':476 'full-text':475 'function':263,294,493 'futur':742,884 'gdpr':589,920 'goal':110 'googl':207,216 'graph':244 'growth':886 'guidanc':87 'guidelin':879 'handl':482,726,964 'harden':599 'heavi':138 'hierarch':273 'high':159,989 'high-perform':158 'high-traff':988 'htap':178,961 'hybrid':25,49,175,221 'i/o':348 'identifi':836 'implement':427,432,445,570,594,609,659,723,859,936 'implic':714 'includ':459 'index':66,308,717,861 'industri':824 'industry-specif':823 'influxdb':240 'inject':583 'input':1033 'inspect':116 'instruct':106 'integr':229,394,547,643,661,678 'intellig':505 'interact':894 'interfac':235 'iot':978 'join':276 'json':470 'json/xml':298 'knowledg':765 'lake':674 'larg':329 'latenc':935 'learn':546 'level':86,556,561 'limit':148,995 'load':135,641 'machin':545 'maintain':701 'mainten':312,878 'manag':321,340,581,603,637,729 'mask':564 'master':4,34,170 'match':1004 'mdx':510 'memori':342 'memsql':226 'methodolog':791 'microservic':446,679 'migrat':380,611,939 'mine':518 'minim':934 'miss':1041 'model':23,405,415,435,790 'modern':5,35,167,196,251,450,751,767,805,855 'mongodb':230 'monitor':370,621,801 'movement':646 'multi':357,915 'multi-region':356 'multi-ten':914 'nativ':10,47,173,203,373,946 'need':83 'neo4j':246 'neptun':248 'non':92 'non-sql':91 'normal':410,746 'nosql':228 'olap':420,506,814 'oltp':812 'oltp/olap':12,50,73,222 'optim':13,39,123,165,260,279,286,306,318,341,349,389,399,512,651,737,783,837,852,895,983 'oracl':942 'orm':85 'orm-level':84 'output':114,1013 'parallel':287 'partit':291,326 'path':121 'pattern':71,444,449,461,682,722,794,808,865 'perform':20,38,64,133,160,303,369,626,638,694,713,748,800,868,985 'permiss':1034 'pipelin':606 'plan':68,102,282,315,378,787 'platform':200,384,777,994 'pool':337,346 'postgresql':252,947 'practic':588,736,811 'prevent':584 'privaci':592 'privileg':580 'pro':3 'procedur':496,631 'process':177,289,300,473,544,648 'product':141 'profession':155 'proper':724,860 'provid':877 'purpos':152 'queri':16,59,63,101,109,124,139,164,257,266,281,288,302,313,489,511,519,526,670,759,782,853,899,928,952,976 'read':145,710 'readabl':757 'real':538,653,925 'real-tim':537,652,924 'realist':762,870 'recognit':462,533 'recoveri':377,630 'recurs':267 'redshift':219 'region':358 'replic':362 'replica':146 'report':573 'requir':749,827,834,892,1032 'resourc':339,403 'respons':830 'retent':956 'revenu':532 'review':1025 'role':575 'role-bas':574 'row':460,555,904 'row-level':554 'saa':917 'safeguard':143 'safeti':136,1035 'scalabl':187,696,882 'scale':366 'scd':431 'schema':104,117,407,423,426,610,843,911 'scope':1006 'search':478 'second':932 'secur':551,557,586,732,796,889 'segment':531 'sensor':979 'seri':238,334,522,974 'serverless':385 'skill':54,79,998 'skill-sql-pro' 'slowli':428 'snowflak':215,425,907 'solut':191,829 'sourc':441,665 'source-sickn33' 'spatial':480 'specialist':33 'specif':465,773,825,1020 'sql':2,6,32,58,70,93,154,183,209,211,234,451,456,549,582,706,752,768,856 'sql-pro':1 'standard':769 'star':422 'start':699 'statist':118,293,320,514 'stop':1026 'storag':351 'store':495 'strategi':280,292,309,327,363,381,413,612,718,804,940 'stream':542,656 'substitut':1016 'success':1038 'synchron':397,681 'syntax':454 'system':27,37,89,162,198,223,421,815,962 'tabl':269,330,484,905 'task':1002 'techniqu':17,43,184,258,277,567,784,857 'tempor':483 'tenant':916 'test':617,642,758,867,1022 'text':477 'thorough':760 'tidb':225 'time':237,333,487,521,539,654,926,958,973 'time-seri':236,332,520,972 'time-travel':486 'timescaledb':241,982 'tool':822 'topic-agent-skills' 'topic-agentic-skills' 'topic-ai-agent-skills' 'topic-ai-agents' 'topic-ai-coding' 'topic-ai-workflows' 'topic-antigravity' 'topic-antigravity-skills' 'topic-claude-code' 'topic-claude-code-skills' 'topic-codex-cli' 'topic-codex-skills' 'track':954 'traffic':990 'trail':569 'trait':691 'transact':728,966 'transactional/analytical':176 'travel':488 'treat':1011 'trigger':689 'tune':21,62,304,347,803 'type':847 'uniqu':780 'updat':325,930 'usag':721,864 'use':52,77,144,750,854,996 'user':491 'user-defin':490 'valid':126,501,619,888,1021 'vault':434 'verifi':130 'version':614 'voltdb':227 'volum':744,764,872 'vs':813 'vulner':596 'warehous':214,418,439,677 'well':704 'well-docu':703 'window':262 'without':142 'workload':74 'write':56,700,712,851","prices":[{"id":"492e89eb-8ce0-4809-88d5-f08547d8c4bb","listingId":"f163f25d-2e30-4b93-aa03-2d79754487cb","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"sickn33","category":"antigravity-awesome-skills","install_from":"skills.sh"},"createdAt":"2026-04-18T21:45:21.068Z"}],"sources":[{"listingId":"f163f25d-2e30-4b93-aa03-2d79754487cb","source":"github","sourceId":"sickn33/antigravity-awesome-skills/sql-pro","sourceUrl":"https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/sql-pro","isPrimary":false,"firstSeenAt":"2026-04-18T21:45:21.068Z","lastSeenAt":"2026-04-22T12:51:49.367Z"}],"details":{"listingId":"f163f25d-2e30-4b93-aa03-2d79754487cb","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"sickn33","slug":"sql-pro","github":{"repo":"sickn33/antigravity-awesome-skills","stars":34515,"topics":["agent-skills","agentic-skills","ai-agent-skills","ai-agents","ai-coding","ai-workflows","antigravity","antigravity-skills","claude-code","claude-code-skills","codex-cli","codex-skills","cursor","cursor-skills","developer-tools","gemini-cli","gemini-skills","kiro","mcp","skill-library"],"license":"mit","html_url":"https://github.com/sickn33/antigravity-awesome-skills","pushed_at":"2026-04-22T06:40:00Z","description":"Installable GitHub library of 1,400+ agentic skills for Claude Code, Cursor, Codex CLI, Gemini CLI, Antigravity, and more. Includes installer CLI, bundles, workflows, and official/community skill collections.","skill_md_sha":"bd93671383b64a877da955ab23d41dcd2804e270","skill_md_path":"skills/sql-pro/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/sql-pro"},"layout":"multi","source":"github","category":"antigravity-awesome-skills","frontmatter":{"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."},"skills_sh_url":"https://skills.sh/sickn33/antigravity-awesome-skills/sql-pro"},"updatedAt":"2026-04-22T12:51:49.367Z"}}