Does it follow specific formatting standards?

Yes, it is designed to be compatible with SQLFluff, enforcing trailing commas, uppercase keywords, and explicit JOIN declarations for cleaner diffs and code reviews.

How does this skill improve query performance?

It implements 'filter early' strategies, encourages the use of EXPLAIN ANALYZE for profiling, and suggests efficient window functions and aggregation patterns.

Can it help with database schema migrations?

Absolutely. It includes standardized patterns for creating tables, indexes, and enums, ensuring your schema is robust and follows modern database design principles.

Does this skill support specific SQL dialects?

Yes, it provides tailored guidance and optimization patterns specifically for PostgreSQL and BigQuery, while adhering to general ANSI SQL best practices.

Why does it emphasize CTEs over subqueries?

CTEs (Common Table Expressions) improve readability and maintainability by breaking complex logic into named, logical steps that are easier to debug and test.

SQL Development

Name: SQL Development
Author: btimothy-har

bybtimothy-har

0•

Database Management

Generates, optimizes, and manages production-grade SQL queries and database schemas with a focus on performance and readability.

This skill equips Claude with specialized expertise for architecting robust SQL queries and database schemas across multiple dialects like PostgreSQL and BigQuery. It enforces industry best practices such as CTE-based query structuring, explicit NULL handling, and performance optimization techniques like early filtering and window function usage. Whether you are building new data models, refactoring legacy queries for better performance, or ensuring linter compliance with SQLFluff, this skill ensures your database logic is consistent, performant, and maintainable.

Key Features

01Standardized SQL formatting including uppercase keywords and explicit JOIN syntax

02CTE-driven query structuring for improved clarity and modular testability

030 GitHub stars

04Rigorous NULL handling patterns to prevent logical errors in data aggregation

05Schema design templates for tables, indexes, and custom enum types

06Platform-aware performance optimization for PostgreSQL and BigQuery environments

Use Cases

01Designing normalized database schemas with proper constraints, indexing, and audit columns

02Refactoring complex, nested subqueries into readable Common Table Expressions (CTEs)

03Optimizing slow-running queries using EXPLAIN plans and early filtering strategies

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add btimothy-har/basecamp sql

For use in Claude.ai and ChatGPT