skills.rest
takeokunn
takeokunnCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

SQL Ecosystem

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
One-click install
npx skills add https://github.com/takeokunn/nixos-configuration --skill sql-ecosystem
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
diegoliriodiegolirio

sql-extract-ddl-oracle-mcp

Export Oracle schema DDL via MCP into Flyway-compatible SQL migrations.

Community
Advanced
Holo00Holo00
6

database-changes

Generate idempotent SQL migrations for IdeaForge database schema changes.

Community
Intermediate
cathayriskcathayrisk

sql-and-database

Provide SQLAlchemy patterns for safe database operations in Python.

Community
Intermediate
ntaksh42ntaksh42
1

database-migration-generator

Generate SQL and TypeORM database migration scripts with rollback support.

Community
Intermediate