SQL

About

Provides specialized guidance for SQLite development, focusing on efficient query writing, modern schema design, and robust migration workflows. This skill enforces specific conventions such as lowercase queries, strict table definitions, and standardized ISO 8601 timestamp handling. It is particularly useful for developers building Go-based applications, offering patterns for prefixed primary keys and automated triggers to ensure data integrity and consistency across the database layer.

Key Features

• Schema design standards using strict tables and unique primary key patterns
• Standardized ISO 8601 date formatting for temporal data
• Guidelines for writing lowercase queries and efficient Common Table Expressions (CTEs)
• Automated timestamp management via SQLite triggers
• Best practices for integrating SQLite with Go application code
• 17 GitHub stars

Use Cases

• Writing and optimizing complex SQLite queries and schema migrations
• Designing robust database architectures with strict typing and automated triggers
• Ensuring consistent SQL coding standards within Go development environments