Database Management Agent Skills

Database WAL Recovery

16

Provides technical procedures and systematic workflows for recovering data from corrupted, encrypted, or inaccessible SQLite Write-Ahead Log (WAL) files.

SPARQL University

16

Constructs and verifies complex SPARQL queries for RDF datasets with a focus on academic ontologies and graph pattern matching.

SQLite DB Truncation Recovery

16

Recovers data from corrupted or truncated SQLite databases by manually parsing binary structures when standard tools fail.

Grey Haven Multi-Tenant Data Modeling

15

Standardize and automate multi-tenant database schema design using SQLModel and Drizzle ORM.

Firebase Firestore Specialist

15

Architects production-ready Firebase Firestore implementations with expert-level NoSQL modeling, real-time synchronization, and robust security rules.

Data Validation & Schema Quality

15

Implements robust data validation and schema alignment using Pydantic v2 for PlanetScale and API services.

Database Design & Schema Standards

15

Enforces standardized database conventions, multi-tenant isolation, and schema best practices for Drizzle ORM and SQLModel.

SQLite Vector Search (sqlite-vec)

14

Implements high-performance vector similarity search and embedding storage directly within SQLite databases.

SQLAlchemy Code Review

14

Reviews SQLAlchemy code to optimize session management, eliminate N+1 queries, and ensure database migration safety.

PostgreSQL Code Review

14

Reviews PostgreSQL code for optimal indexing, JSONB performance, connection pooling, and transaction safety.

Kafka CLI Tools & Operations

13

Manages Apache Kafka clusters and data streams using modern CLI tools like kcat, kaf, and kafkactl.

Kafka MCP Integration

13

Simplifies the integration and configuration of Model Context Protocol (MCP) servers for managing Kafka operations directly within AI coding environments.

Confluent ksqlDB Stream Processing

13

Master real-time event streaming and data processing using ksqlDB's SQL-like syntax on Kafka topics.

dbt Semantic Layer Architect

13

Simplifies the creation and management of dbt Semantic Layer components including semantic models, metrics, and dimensions.

dbt Fusion Migration

13

Migrates dbt Core projects to the dbt Fusion engine by resolving compatibility errors, deprecations, and unsupported configurations.

dbt Analytics Engineering

13

Streamlines data transformation and analytics engineering workflows by applying software engineering best practices to dbt projects.

Confluent Kafka Connect

13

Configures and optimizes Kafka Connect pipelines for seamless data movement between databases, cloud storage, and search indexes.

Database Administrator

13

Manages database operations, performance tuning, and high availability configurations across multiple DBMS platforms through a structured workflow.

Data Architecture & Modern Platforms

12

Designs modern data platforms and implements scalable data architecture patterns like data lakes, lakehouses, and data mesh.

Data Modeling & Database Design

12

Designs and documents robust data structures using Entity-Relationship Diagrams, data dictionaries, and multi-level schema models.

ETL & ELT Design Patterns

12

Provides architectural guidance and implementation patterns for designing modern data pipelines and transformation workflows.

Event Sourcing Design

12

Architects and implements robust event-sourced systems using standardized patterns for event stores, aggregates, and projections.

Data Modeling & Schema Design

12

Designs optimized database schemas and guides architectural decisions for operational and analytical systems.

Vector Database Systems Design

12

Architects high-performance vector search systems by providing guidance on database selection, ANN algorithms, and scaling strategies.

SurrealDB Query Assistant

11

Generates production-ready SurrealQL queries and schemas for multi-model database applications including document, graph, and relational patterns.

SAP ABAP CDS Development

11

Streamlines SAP ABAP Core Data Services development by providing expert guidance on data modeling, view entities, and semantic annotations.

SAP HANA Developer CLI

11

Streamlines SAP HANA database development and administration using the hana-cli tool for object inspection, SQL execution, and metadata conversion.

SAP SQLScript & HANA Development

11

Develops, optimizes, and debugs production-ready SAP HANA SQLScript procedures and ABAP Managed Database Procedures (AMDP).

SAP Datasphere Development

11

Streamlines SAP Datasphere development by providing expert guidance on data modeling, integration flows, and cloud-native data warehousing on SAP BTP.

CQRS and Event Sourcing Architect

Implements robust Command Query Responsibility Segregation and Event Sourcing patterns for complex, scalable distributed systems.