skills.rest
motoki317
motoki317COMMUNITY
Explore all skills by this author →
Website𝕏@motoki1_GitHub

SQL Ecosystem

Provide SQL patterns for database design, querying, and migrations across PostgreSQL, MySQL, and SQLite.

4|Updated Oct 20, 2025
Search Tags:#security#postgresql#migrations#sql#query-optimization#database-design#parameterized-queries
One-click install
npx skills add https://github.com/motoki317/dotfiles --skill sql-ecosystem-motoki317
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: SQL Ecosystem
Source: https://github.com/motoki317/dotfiles/tree/main/.claude/skills/sql-ecosystem
Command: npx skills add https://github.com/motoki317/dotfiles --skill sql-ecosystem-motoki317

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Helps developers design, query, and optimize SQL databases by providing structured patterns, safe practices, and reusable templates across major engines (PostgreSQL, MySQL, SQLite).

Core Features & Use Cases

  • DDL Patterns: Create tables, constraints, and indexes with best practices for scalable schemas.
  • DML Patterns: Safe, parameterized queries, upserts, and soft deletes to prevent injection and maintain auditability.
  • Joins & Subqueries: Efficient data retrieval using INNER/LEFT/RIGHT/FULL joins and common table expressions (CTEs).
  • Query Optimization: Indexing strategies, EXPLAIN guidance, and performance-conscious query construction.
  • Migrations & Anti-Patterns: Zero-downtime migration techniques and avoidance of common SQL pitfalls.

Quick Start

Ask me to generate optimized, secure SQL patterns and migration strategies for PostgreSQL, MySQL, and SQLite.

Frequently Asked Questions about SQL Ecosystem

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

FAQPage Schema
How do I write parameterized queries and prevent SQL injection across PostgreSQL, MySQL, and SQLite?▼

Parameterized queries prevent SQL injection by separating SQL logic from data values. This Skill provides safe DML patterns, upserts, and soft delete templates using parameterized queries applicable across PostgreSQL, MySQL, and SQLite.

What's the best way to handle zero-downtime database migrations and avoid common SQL anti-patterns?▼

Zero-downtime database migrations require careful schema alteration techniques to avoid locking tables. This Skill offers migration strategies and highlights common SQL anti-patterns to ensure smooth, real-world schema evolution.

How do I optimize SQL query performance using indexing strategies and EXPLAIN?▼

SQL query optimization uses indexing strategies and EXPLAIN plans to identify bottlenecks and improve data retrieval speed. This Skill provides guidance on performance-conscious query construction and indexing for scalable schemas.

When do I use CTEs, window functions, and complex joins for efficient data retrieval?▼

CTEs, window functions, and complex joins organize complex data retrieval logic into readable, efficient structures. This Skill demonstrates efficient patterns using INNER, LEFT, RIGHT, and FULL joins alongside common table expressions.

Does this SQL guidance cover DDL patterns for scalable database design and constraints?▼

Yes, this SQL guidance covers DDL patterns for creating tables, constraints, and indexes. It provides best practices for scalable schemas and database design applicable across PostgreSQL, MySQL, and SQLite environments.

Related Skills

Explore More Software Engineering Skills→
cyphercr0wcyphercr0w
8

database-migrations

Guide PostgreSQL, MySQL, and ORM database schema migrations with rollback planning.

Community
Advanced
EIS-ITSEIS-ITS

Backend Queries

Generate secure, optimized database queries with parameterized statements, eager loading, indexing, and transactions.

Official
Intermediate
HollowvynHollowvyn

drizzle-orm

Implement type-safe database access with Drizzle ORM for TypeScript projects.

Official
Intermediate
tuyenhttuyenht

NoSQL Patterns

Provide expert patterns for optimizing MongoDB, Redis, and DynamoDB databases.

Community
Intermediate