PostgreSQL database administration — backup/restore (pg_dump, PITR, WAL archiving), health monitoring (connections, bloat, cache hit ratio, dead tuples), connection pooling…
Expert database architecture including schema design, partitioning, replication, and performance optimization
PostgreSQL 데이터베이스 백업 및 복원. Docker/로컬 환경 지원.
Use when setting up database connections, especially for Neon PostgreSQL. Triggers for: Neon Postgres connection, connection pooling configuration, connection string management,…
Validate that a generic Postgres database (GCP Cloud SQL, GKE Autopilot, self-hosted, etc.) is reachable via psql or pg_dump, introspect a user-scoped subset of the schema…
Validate that a Supabase MCP server is reachable, introspect a user-scoped subset of the database (tables, columns, types, RLS policies, optionally functions and recent…
MongoDB database exploration and querying. Use when you need to understand database structure, view existing data, check collection schemas, count documents, or run queries to…
Especialista Sênior em MongoDB, Segurança de Dados, Migrations, Backup/Recovery e Data Integrity. Guardian dos dados do Super Cartola Manager com foco em operações seguras,…
Lint PostgreSQL functions against schema, analyze usage, and generate fix reports; use when detecting broken functions, validating schema contracts, or cleaning up unused database…
Creates a database migration using Drizzle. Use this EVERY TIME you need to modify the database schema.
Migrate a Ruby on Rails application's primary database from MySQL to PostgreSQL — schema upgrades (JSON to JSONB for queryability, ENUMs to native types or check constraints,…
Migrate a Ruby on Rails application from Oracle Database to PostgreSQL — schema differences (NUMBER to BIGINT/DECIMAL, VARCHAR2 to VARCHAR, CLOB/BLOB to TEXT/BYTEA, sequences,…
Migrate a Ruby on Rails application's primary database from PostgreSQL to MySQL — schema differences (JSONB to JSON, ARRAY columns, partial indexes, CHECK constraints, sequences),…
PostgreSQL database operations specialist using Drizzle ORM for schema management, queries, and migrations
Patterns for optimizing database queries and preventing connection pool exhaustion. Use when writing batch operations, debugging slow queries, or reviewing code for performance.
Menulis atau mengubah apps/api/prisma/schema.prisma beserta langkah migrasi yang aman untuk PostgreSQL.
データベースクエリ・分析支援。SQLクエリの作成、実行、結果の分析を行う。BigQuery、PostgreSQL、MySQL対応。トリガー: /db-query, SQL, クエリ, データ分析, BigQuery
트리거: "DB 설계", "테이블 설계", "ERD 만들어줘", "데이터베이스 설계", "스키마 설계해줘", "테이블 구조 잡아줘" 수행: 요구사항 문장을 분석하여 ERD(텍스트/Mermaid 형식) + DDL SQL을 생성한다.
Thiết kế DB schema production → apply lên PostgreSQL → dùng sqlacodegen reverse-engineer SQLAlchemy models → tự động fix cú pháp. Dành cho FastAPI + PostgreSQL projects.
Validate Laravel database configuration and test actual connections. Use when user reports "database connection error", "hosts array is empty", "could not connect to database", or…
Prüft die Reihenfolge nationales Steuerrecht und DBA bei beschraenkter Steuerpflicht: DBA begruenden grundsaetzlich keine Steuerpflicht, § 49 EStG muss den…
Methodenartikel Art. 23A und Art. 23B OECD-Musterabkommen und Wahl zwischen Anrechnung und Freistellung mit Progressionsvorbehalt.
Ansaessigkeit nach Art. 4 OECD-Musterabkommen und Tie-Breaker-Regelungen bei mehrfacher Ansaessigkeit.
Betriebsstaette nach Art. 5 OECD-Musterabkommen einschließlich BEPS- und MLI-Anpassungen. Anwendungsfall Steuerberater prüfen ob ausländische Aktivitaet eines deutschen U — from…
Dividenden nach Art. 10 OECD-MA und EU-Mutter-Tochter-Richtlinie. Anwendungsfall Ausschuettungen über Grenze Quellensteuer im Quellenstaat Hoechstsatz Schachtelhoehe.
DBA Deutschland Frankreich aus 1959 mit Änderungsprotokollen. Anwendungsfall Pendler im Elsass und Lothringen Grenzgaengerregelung 20-km-Zone. Beteiligungen Pensionen Lizenzen.
Grundprinzipien des OECD-Musterabkommens 2017 inkl. BEPS-Anpassungen und MLI für die Prüfung deutscher Doppelbesteuerungsabkommen.
Kuenstler und Sportler nach Art. 17 OECD-MA mit Auftrittsstaat-Besteuerung. Anwendungsfall Musiker Schauspieler Sportler mit Auftritten in mehreren Staaten.
Lizenzgebühren nach Art. 12 OECD-MA und EU-Zins-Lizenzgebühren-Richtlinie. Anwendungsfall Software-Lizenz Patent Marken IP-Box-Konstruktionen.
Verständigungsverfahren und EU-Streitbeilegung bei DBA-Doppelbesteuerung prüfen: Art. 25 OECD-MA, bilaterale MAP, EU-DBA-Streitbeilegungsgesetz, Fristen, Antrag, Begründu — from…
PostgreSQL heuristics catalogue for the dba role. Detects indexing, modeling, query, migration, retention, capacity, security, and concurrency problems specific to Postgres.
Investigate RDS PostgreSQL slow query performance using pg_stat_statements. Use when CloudWatch RDS CPUUtilization alarm fires, application reports slow queries, or…
Rentenbesteuerung nach Art. 18 OECD-MA und Sonderregelungen einzelner DBA. Anwendungsfall Rentner mit Wohnsitz im Ausland (Spanien Portugal Italien Tuerkei Schweiz Oester — from…
执行 MySQL、PostgreSQL、Oracle、SQL Server、DM8、TiDB 数据库健康巡检，内置 130+ 条增强风险分析规则 + 慢查询深度分析引擎 + 本地 Ollama AI 大模型诊断建议，一键生成专业 Word 巡检报告。适用于 DBA…
Structured debugging session — reproduce, isolate, diagnose, and fix. Trigger with an error message or stack trace, "this works in staging but not prod", "something broke — from…
DBIO-Klassenpattern mit CAG (Class::Accessor::Grouped). Nutze wenn du DBIO-Klassen baust oder refactorst.
Guide for building reliable, fault-tolerant Go applications with DBOS durable workflows. Use when adding DBOS to existing Go code, creating workflows and steps, or using queues…
Guide for building reliable, fault-tolerant Python applications with DBOS durable workflows. Use when adding DBOS to existing Python code, creating workflows and steps, or using…
Guide for building reliable, fault-tolerant TypeScript applications with DBOS durable workflows. Use when adding DBOS to existing TypeScript code, creating workflows and steps, or…
dbt Core/Cloud data transformations, testing, documentation, and CI/CD. Activate on: dbt, data transformation, analytics engineering, ref, source, staging model, mart, dbt test.
dbt (data build tool) patterns for model organization, incremental strategies, and testing.
Parses dbt project artifacts (manifest.json and catalog.json) to build a lineage graph and identify models with no tests, stale documentation, or missing uniqueness assertions.
Comprehensive guide to dbt (data build tool) patterns, modeling best practices, testing strategies, and production workflows for modern data transformation
ALWAYS USE when working with dbt models, SQL transformations, tests, snapshots, or macros. Use IMMEDIATELY when editing dbt_project.yml, profiles.yml, or creating SQL models.
Use when creating or modifying dimensional dbt models in warehouse-backed analytics projects. Covers a four-layer warehouse architecture (sources/staging/core/marts), naming…
Dbt Test Creator - Auto-activating skill for Data Pipelines. Triggers on: dbt test creator, dbt test creator Part of the Data Pipelines skill category.
dbt testing strategies using dbt_constraints for database-level enforcement, generic tests, and
Production-ready patterns for dbt (data build tool) including model organization, testing strategies, documentation, and incremental processing.
Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies.
Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies.
Write dbt unit-test specs with given/when/expect shape. Seeded from dbt-labs/dbt-agent-skills (Feb 9 2026).
Use when reading dbt artifacts or generating ERDs inside dbdocs — parsing manifest.json/catalog.json and producing Mermaid ERDs via the dbterd Python API for the generated…
Builds a transparent Discounted Cash Flow (DCF) valuation with a 5-10 year forecast, terminal value, Weighted Average Cost of Capital (WACC) derivation, sensitivity tables, and a…
Use when dcNess routes architecture-validator cross-review work to Codex before implementation or architecture PR merge to validate design contracts read-only.
일반 Kotlin data class를 DynamoDB DbItem 세트(data class, Converter, Repository)로 변환합니다. 키워드: DynamoDB, DbItem, DbConverter, DbRepository, ddbJoin, ddbSplit, PK/SK, GSI
Use for DDD aggregate design, implementation, refactoring, or review. Covers aggregate boundaries, aggregate roots, true invariants, immutable updates, ID references, eventual…
Use this agent when you need expert guidance on Domain-Driven Design including bounded contexts, context mapping, and aggregate design.
Full-project DDD compliance audit — scans ALL Java files against every DDD layer rule. Use for architecture reviews, onboarding, and pre-release checks.
Strategic and Tactical expertise in Gravito DDD. Trigger this for complex domains requiring Bounded Contexts, Aggregates, and Event-Driven architecture.
Use when planning a DDD implementation flow that starts from the domain model and tests before infrastructure.