Database Management Agent Skills

Logseq DB Knowledge

Provides comprehensive guidance on working with Logseq's database-based data model, covering nodes, typed properties, classes, and advanced Datalog queries.

Backend Models

Defines and optimizes database models with appropriate data types, relationships, and integrity constraints across various ORM frameworks.

Backend Queries

Writes secure, performant database queries and data access logic using optimization techniques and security best practices.

Backend Migrations

Manages database schema changes through version-controlled migration files while ensuring rollback safety and zero-downtime compatibility.

Query Expert

Generates, optimizes, and troubleshoots database queries across multiple SQL and NoSQL systems to ensure peak performance and scalability.

Mirrord DB Branching

Configures isolated database branches for safe, production-like development and testing without affecting live data.

SurrealDB Expert

Architects, optimizes, and secures SurrealDB applications using multi-model database patterns and real-time capabilities.

AI Agent Property Manager

Automates the multi-step process of adding new comparison properties to the AI coding agents matrix across data files, UI components, and GitHub templates.

C# Database Access Patterns

Streamlines RDBMS integration in C# for PostgreSQL, MySQL, DuckDB, and legacy systems using optimized access patterns and drivers.

PostGIS Spatial Database

Enforces PostGIS 3.6.1 best practices for managing complex geographic data, spatial queries, and advanced geometry operations.

Typedown Expert

Transforms unstructured Markdown documentation into rigorous, machine-verifiable data schemas using Pydantic models and YAML entities.

Smoke Test Database

Validates database connectivity, performance SLAs, schema integrity, and backup readiness during software release workflows.

Doctrine Elegant Entity Generator

Generates Doctrine entities and repositories following Elegant Objects principles for robust, maintainable PHP code.

Snowflake Semantic View Manager

Automates the creation, validation, and management of Snowflake semantic views and semantic layer definitions using the Snowflake CLI.

PostgreSQL Patterns & Optimization

Optimizes PostgreSQL database performance and security through standardized schema design, indexing strategies, and advanced query patterns.

PostgreSQL Development Patterns

Enforces transaction safety, strict typing, and naming conventions for PostgreSQL to prevent data corruption and runtime errors.

TimescaleDB Time-Series Optimization

Optimizes time-series data management by enforcing TimescaleDB 2.24.0 best practices for hypertables, continuous aggregates, and compression.

PostgreSQL 18 Architecture

Enforces PostgreSQL 18 best practices for schema design, migrations, and high-performance database architecture.

ActiveRecord

Streamlines Ruby on Rails database management with expert patterns for migrations, associations, and query optimization.

Supabase RLS Fixer

Resolves Supabase Row Level Security issues and manages user context for background jobs and system processes.

Database Patterns & Schema Design

Implement production-grade database architectures, optimized queries, and robust migration strategies using modern ORMs and SQL best practices.

Database Management & Schema Optimization

Manages database schemas, migrations, and performance optimizations using Drizzle ORM and Neon Postgres.

Database Design Patterns

Optimizes database architectures through expert schema design, query tuning, and scalable persistence patterns for SQL and NoSQL environments.

Supabase Local Development

Streamlines the setup and management of local Supabase environments for faster, offline-ready full-stack development.

SQL Design Patterns

Provides a comprehensive reference for advanced SQL syntax, optimization strategies, and common query implementation patterns.

SQLite Operations

Implements robust SQLite database patterns for Python projects, including state management, async operations, and high-performance configurations.

Supabase Realtime

Enable real-time data synchronization and event listening for Supabase applications directly within your development environment.

Kysely Query Converter

Transforms raw SQL queries into type-safe Kysely TypeScript code for streamlined database management.

Atlan SQL Connector Patterns

Guides the development of Atlan SQL metadata and query extraction connectors by selecting and implementing standardized SDK patterns.

Kysely SQL Converter

Converts raw SQL queries into type-safe Kysely TypeScript code to streamline database layer development.