Best Best AI Agent Skills for Database Engineers

A guide for designing tables in PostgreSQL to optimize for normalization, data types, indexing, and performance.

Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.

Master database schema and data migrations across ORMs (Sequelize, TypeORM, Prisma), including rollback strategies and zero-downtime deployments.

.NET Backend Development Patterns for production-grade APIs, MCP servers, and enterprise backends using C#/.NET.

Comprehensive guide to designing event stores for event-sourced applications.

Comprehensive guide to building projections and read models for event-sourced systems.

Implements systematic checks for data quality in pipelines using frameworks like Great Expectations and dbt. By automating these validations, it ensures data accuracy, consistency, and compliance, significantly reducing manual oversight and error rates.

Facilitates the organization and quality assurance of data transformation models using dbt. This skill enhances data integrity and efficiency by providing structured patterns for building reliable data pipelines and documentation.

Handles Prisma ORM tasks such as schema design, migrations, and query optimization for various databases. It enhances efficiency by improving database operations and preventing common pitfalls through strategic guidance and best practices.

Facilitates the process of designing effective database schemas by considering normalization, primary keys, and relationships. This helps developers create well-structured databases, minimizing data redundancy and improving query performance.

Implements high-performance analytics patterns for ClickHouse database management. By utilizing these patterns, users can optimize data storage and query execution, leading to efficient performance in analytical processing tasks.

Full-stack Nuxt framework with database, KV, blob, and cache. Multi-cloud support (Cloudflare, Vercel, Deno, Netlify).

Handles serverless database management for Postgres projects, enabling seamless autoscaling and instant restores. By installing this skill, developers benefit from reduced infrastructure management overhead and enhanced performance scalability without manual intervention.

Creates and manages SQLite databases with D1 on Cloudflare Workers. Streamlines database operations and reduces migration headaches through built-in automation features.

Handles complex content management tasks with features such as access control, versioning, and custom APIs. By installing it, developers streamline the creation and management of dynamic applications with reduced coding effort and enhanced functionality.

Provides a comprehensive guideline for implementing security and performance best practices in Supabase applications. By following these rules, developers can ensure more secure coding practices that reduce vulnerabilities and enhance application stability.

Manages serverless PostgreSQL connections for applications on Neon and Vercel. By installing this skill, developers streamline database interaction and effectively prevent common issues like connection exhaustion and SQL injection.

Provides best practices for writing SQL queries and designing database schemas in PostgreSQL projects. By installing it, developers can enhance database performance and ensure optimal query execution through established patterns and techniques.

Facilitates access to genetic variant data from ClinVar for research and clinical interpretation. By employing this skill, users can effectively analyze genomic variations, saving time and enhancing the accuracy of genetic assessments.

Handles comprehensive search and retrieval of purchasable chemical compounds from the ZINC database. Facilitates efficient drug discovery and virtual screening by providing quick access to molecular structures and related data through various search parameters.

Facilitates comprehensive searches and data retrieval related to small molecule metabolites in human biology. Researchers benefit from streamlined access to metabolite information, reducing time spent on manual searches and ensuring more accurate identification in metabolomics studies.

Facilitates the design of efficient database schemas for distributed NoSQL systems, focusing on query-first modeling. By adopting targeted patterns, developers can optimize data access and minimize latency issues in large-scale applications.

Optimizes database performance by analyzing slow queries and configuring appropriate indexing strategies. This skill allows developers to enhance application performance and reliability by effectively managing PostgreSQL databases.

LaminDB handles the task of managing and querying biological datasets efficiently. By automating data lineage tracking and providing standardized metadata, it enhances reproducibility and compliance with FAIR data principles.

Handles TypeScript-first object relational mapping in modern web applications, allowing developers to define and manage database schemas using familiar TypeScript syntax. By streamlining database interactions and enforcing compile-time type safety, it reduces runtime errors and enhances developer productivity in serverless environments.

Facilitates the creation of secure and efficient Supabase integrations by defining best practices for database design and Row Level Security (RLS) policies. Developers benefit by streamlining integration processes, ensuring robust security, and minimizing common pitfalls in setup.