SQL Ecosystem

Name: SQL Ecosystem
Availability: InStock
Author: take

Provides SQL patterns for designing, optimizing, and writing portable code across databases.

71|2|Updated Feb 23, 2024

Search Tags:#migrations #PostgreSQL #sql #MySQL #transactions #database-patterns

Ready to run

npx skills add https://github.com/takeokunn/nixos-configuration --skill sql-ecosystem

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: SQL Ecosystem
Source: https://github.com/takeokunn/nixos-configuration/tree/main/home-manager/programs/claude-code/skills/ecosystem/sql-ecosystem
Command: npx skills add https://github.com/takeokunn/nixos-configuration --skill sql-ecosystem

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a centralized set of SQL patterns and best practices to help developers design robust schemas, write secure queries, and manage migrations across multiple databases.

Core Features & Use Cases

Comprehensive SQL fundamentals: ANSI SQL data types, DDL, DML patterns, and portability notes across PostgreSQL, MySQL, and SQLite.
Safety and correctness: Parameterized queries, safe LIKE patterns, and explicit transaction boundaries to prevent data corruption and injection risks.
Design, migration, and optimization: Patterns for constraints, indexing, soft deletes, and migration-friendly schema design, plus guidance on explain plans and query tuning.

Quick Start

Use this skill to generate a starter guide for safe SQL patterns including table creation, constraints, indexing, and transaction examples.

Frequently Asked Questions about SQL Ecosystem

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

FAQPage Schema

How do I write safe SQL patterns for schema migrations across PostgreSQL and MySQL?▼

To write safe SQL patterns for schema migrations, use explicit transaction boundaries, parameterized queries, and constraint-based DDL templates to ensure data integrity across PostgreSQL, MySQL, and SQLite.

What are the best practices for portable SQL data types and constraints across different databases?▼

Portable SQL data types and constraints rely on ANSI SQL standards, utilizing DDL templates and portability notes to maintain consistent schema design across PostgreSQL, MySQL, and SQLite.

How do I prevent SQL injection when writing DML and LIKE queries?▼

Prevent SQL injection in DML and LIKE queries by using parameterized queries and safe LIKE patterns, ensuring secure data manipulation and protecting against unauthorized database access.

Does this SQL skill provide indexing and optimization patterns for query tuning?▼

Yes, the SQL skill provides indexing patterns, soft deletes, and guidance on explain plans for query tuning and optimization across supported databases to improve data retrieval performance.

When do I need explicit transaction boundaries in database operations?▼

Explicit transaction boundaries are needed during complex data manipulation and migrations to prevent data corruption, ensuring atomic operations and reliable database state transitions across PostgreSQL and MySQL.