hanifalkauni

Dba Architect — Data skill for Claude Code

Data community

🗄️ Principal Database Administrator (DBA) & Data Architecture MCP Server + Multi-Agent Skill for PostgreSQL & MySQL.

How to install Dba Architect

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

What Dba Architect does

🗄️ Principal Database Administrator (DBA) & Data Architecture MCP Server + Multi-Agent Skill for PostgreSQL & MySQL. Deterministic schema audits, ESR indexing, N+1 detection, EXPLAIN plans & zero-downtime migrations.

Alternatives in Data

Portaljs Architect — Recommend a data-portal architecture (storage, compute, catalog, access, hosting, metadata) from your needs, t 2.3k ★
MySQL — Safe read-only SQL queries against MySQL databases 159 ★
Postgres Wizard — 🗄️ PostgreSQL Wizard 96 ★

README

🗄️ DBA-Architect

**Principal Database Administrator (DBA) & Data Architecture AI Skill Agent + MCP Server** *Autonomously audit SQL migrations, optimize composite B-Tree indexes via ESR rules, eliminate N+1 queries, diagnose EXPLAIN plans, execute zero-downtime migrations, and prevent transaction deadlocks for PostgreSQL & MySQL.*

[![License: MIT](https://img.shields.io/badge/License-MIT-blue.svg?style=for-the-badge)](LICENSE) [![Version](https://img.shields.io/badge/version-1.0.0-7aa2f7.svg?style=for-the-badge)](package.json) [![Node.js](https://img.shields.io/badge/Node.js-%3E%3D20.0.0-339933?style=for-the-badge&logo=nodedotjs)](https://nodejs.org) [![TypeScript](https://img.shields.io/badge/TypeScript-5.6-3178C6?style=for-the-badge&logo=typescript)](https://www.typescriptlang.org) [![MCP Protocol](https://img.shields.io/badge/Protocol-MCP%20JSON--RPC-8A2BE2?style=for-the-badge)](https://modelcontextprotocol.io) [![PostgreSQL](https://img.shields.io/badge/PostgreSQL-v14--v17+-4169E1?style=for-the-badge&logo=postgresql&logoColor=white)](https://www.postgresql.org) [![MySQL](https://img.shields.io/badge/MySQL-InnoDB%20v8.0+-4479A1?style=for-the-badge&logo=mysql&logoColor=white)](https://www.mysql.com) [![Tests Passing](https://img.shields.io/badge/Tests-18%2F18%20Passing-success?style=for-the-badge&logo=vitest)](tests) [![WCAG 2.2 AA](https://img.shields.io/badge/A11y-WCAG%202.2%20AA-9ece6a?style=for-the-badge)](https://www.w3.org/WAI/standards-guidelines/wcag/)

[English](README.md) | [Bahasa Indonesia](README.id.md)

🌟 Overview

**DBA-Architect** bridges the gap between software development and deep database performance engineering. Modern AI assistants often guess or generate naive SQL recommendations; **DBA-Architect** replaces guesswork with **8 deterministic AST & heuristic engines** built upon battle-tested database administration playbooks.

Whether you are authoring a DDL migration in Prisma, tuning an e-commerc