u1pns

Skill Dba — Data skill for Claude Code

Data community

A comprehensive, engine-aware Database Administration (DBA) SKILL designed for AI CLI agents (like Claude Code, Gemini CLI, OpenCode).

How to install Skill Dba

This entry records only its repository, not the path inside it, so there is no exact command to give. Open u1pns/skill-dba and copy the folder into ~/.claude/skills/, or the file into ~/.claude/agents/.

What Skill Dba does

A comprehensive, engine-aware Database Administration (DBA) SKILL designed for AI CLI agents (like Claude Code, Gemini CLI, OpenCode).

Alternatives in Data

Privacy & Data Handling — This repository contains: - a plugin package (plugins/compound-engineering) made of markdown/config content 10.8k ★
Opencode Mem — OpenCode plugin that gives coding agents persistent memory using local vector database 1.5k ★
Claude Deep Research Skill — Enterprise-grade deep research skill for Claude Code with 8-phase pipeline, source credibility scoring, and au 1k ★

README

DBA AI Skill (Super DBA)

A comprehensive, engine-aware Database Administration (DBA) toolkit designed for AI CLI agents (like Claude Code, Gemini CLI, OpenCode).

🎯 Intention & Goal

The goal of this skill is to transform your AI assistant into a Senior Database Administrator. Instead of relying on generic or hallucinated SQL advice, this skill provides the AI with strict, battle-tested rules for schema design, query optimization, indexing strategies, and zero-downtime migrations.

It is structured using an **80/20 architecture**:

SKILL.md (Root): Contains the 80% universal rules for all relational databases (SARGability, Normalization, Leftmost Prefix).
references/ (Folder): Contains the 20% engine-specific deep dives (Execution Plans, advanced DDL gotchas, and diagnostic scripts) that the AI reads dynamically when needed.

🗄️ Supported Databases

This skill is highly specialized and handles the historical quirks, breaking changes, and performance tuning for the world's Top 5 Relational Database Management Systems (RDBMS):

MySQL: From 5.7 legacy traps (missing CTEs, ignored CHECK constraints) up to modern 8.0/8.4 LTS gotchas (implicit sorting removal, ONLY_FULL_GROUP_BY enforcement).
PostgreSQL: Deep knowledge of PG 11 through 15+ breaking changes (the death of OIDs, the public schema security trap, CTE materialization changes, and B-Tree deduplication).
Microsoft SQL Server (T-SQL): Advanced insights on DMVs, Execution Plans, and version traps (like the STRING_SPLIT ordering glitch or NOLOCK abuse).
Oracle: Mastery of PL/SQL collections, 12c Identity columns (escaping Sequence-Trigger hell), the ROWNUM pagination nightmare, and the 23ai BOOLEAN miracle.
SQLite: Navigating the transition from legacy "Flexible Typing" to Modern STRICT tables, the addition of DROP COLUMN support, and JSONB.