skills.rest
fakhriaditiarahman
fakhriaditiarahmanCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

sql-pro

Optimize SQL queries and design data models for Snowflake, BigQuery, and PostgreSQL.

1|Updated Jan 20, 2026
Search Tags:#analytics#database#optimization#data modeling#sql#cloud#performance tuning
One-click install
npx skills add https://github.com/fakhriaditiarahman/Your-Skill-Agent --skill sql-pro-fakhriaditiarahman
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/fakhriaditiarahman/Your-Skill-Agent/tree/main/.agent/skills/sql-pro
Command: npx skills add https://github.com/fakhriaditiarahman/Your-Skill-Agent --skill sql-pro-fakhriaditiarahman

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill addresses the complexities of modern database management, enabling users to optimize SQL queries, design robust data models, and leverage advanced analytical techniques for cloud-native and hybrid OLTP/OLAP systems.

Core Features & Use Cases

  • Performance Tuning: Optimize query execution plans, indexing strategies, and database configurations for maximum efficiency.
  • Data Modeling: Design and implement advanced schemas for data warehouses, OLTP systems, and microservices.
  • Advanced Querying: Utilize complex SQL features like window functions, CTEs, and temporal queries for sophisticated data analysis.
  • Cloud Database Expertise: Navigate and optimize deployments on platforms like Snowflake, BigQuery, Aurora, and more.
  • Use Case: A user needs to significantly speed up a slow-running analytical query on a large dataset in Snowflake. They can use this skill to analyze the query plan, suggest optimal indexing, and rewrite the query for better performance.

Quick Start

Use the sql-pro skill to optimize the following analytical query for Snowflake: SELECT * FROM large_table WHERE date BETWEEN '2023-01-01' AND '2023-12-31';

Frequently Asked Questions about sql-pro

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow SQL queries in Snowflake?▼

Optimize slow SQL queries in Snowflake by analyzing the query execution plan, applying optimal indexing strategies, and rewriting the query using advanced techniques to enhance database performance and reduce execution time.

What is the best way to design data models for cloud data warehouses?▼

The best way to design data models for cloud data warehouses involves implementing advanced dimensional modeling schemas tailored for OLAP systems, ensuring robust data architecture that supports efficient analytical querying across large datasets.

Can I use advanced SQL features like window functions and CTEs for data analysis?▼

Yes, you can use advanced SQL features like window functions, CTEs, and temporal queries to perform sophisticated data analysis and extract complex insights from your OLTP or OLAP database systems.

Does this approach work for both OLTP and OLAP database systems?▼

Yes, this approach works for both OLTP and OLAP database systems, providing specialized performance tuning, index strategies, and data modeling techniques suitable for hybrid cloud-native environments.

How do I tune database performance for PostgreSQL and BigQuery?▼

Tune database performance for PostgreSQL and BigQuery by analyzing query plans, optimizing database configurations, and leveraging cloud-native deployment strategies to maximize query execution efficiency.

Related Skills

Explore More Software Engineering Skills→
herdiansahherdiansah
23

sql-pro

Optimize SQL queries and database schemas for cloud-native OLTP/OLAP systems.

Community
Advanced
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
chicanoandres702chicanoandres702

data-engineering-data-pipeline

Design and orchestrate scalable batch and streaming data pipelines.

Community
Advanced
chatermchaterm
50

sql-optimization

Analyze SQL execution plans and optimize indexes for MySQL and PostgreSQL queries.

Community
Intermediate