Can this skill help me optimize slow-running queries?

Yes, it specializes in query analysis using tools like EXPLAIN ANALYZE and suggests specific indexing strategies (composite, partial, etc.) to improve performance.

Does it provide support for modern ORMs?

Absolutely. It includes specific patterns and best practices for popular ORMs including Prisma, SQLAlchemy, and TypeORM.

How does it ensure database migration safety?

The skill follows strict migration best practices, emphasizing atomic changes, reversibility (rollbacks), and data safety checks to prevent downtime or data loss.

Which database engines does the Database Assistant support?

The skill is engine-agnostic and provides expertise for major relational databases like PostgreSQL, MySQL, and SQLite, as well as NoSQL concepts and modern ORMs.

Database Assistant

Name: Database Assistant
Author: always-further

byalways-further

•

Database Management

Expertly designs database schemas, optimizes complex SQL queries, and manages data migrations with industry-leading best practices.

About

The Database Assistant skill transforms Claude into a high-level database architect and administrator, providing specialized guidance for every stage of the data lifecycle. It excels at designing normalized relational schemas, implementing efficient indexing strategies, and writing high-performance SQL for read-heavy or complex workloads. Whether you are troubleshooting slow queries using EXPLAIN ANALYZE, implementing soft deletes, or configuring modern ORMs like Prisma and SQLAlchemy, this skill ensures your data layer is scalable, integrity-locked, and optimized for growth. It is the ideal companion for backend developers needing to manage migrations safely and implement robust many-to-many or one-to-many relationship patterns.

Key Features

Advanced query optimization including indexing strategies and EXPLAIN ANALYZE interpretation.
1 GitHub stars
Safe migration planning focusing on atomicity, reversibility, and zero-downtime practices.
Implementation of common data patterns such as soft deletes and complex join structures.
Schema design optimization using 1NF, 2NF, and 3NF normalization standards.
Comprehensive ORM support for Prisma, TypeORM, and SQLAlchemy implementation.

Use Cases

Architecting a scalable multi-tenant database schema for a new SaaS platform.
Refactoring slow-performing legacy SQL queries to reduce server load and latency.
Generating and testing reversible migration scripts for production database updates.

About

Key Features

Advanced query optimization including indexing strategies and EXPLAIN ANALYZE interpretation.
1 GitHub stars
Safe migration planning focusing on atomicity, reversibility, and zero-downtime practices.
Implementation of common data patterns such as soft deletes and complex join structures.
Schema design optimization using 1NF, 2NF, and 3NF normalization standards.
Comprehensive ORM support for Prisma, TypeORM, and SQLAlchemy implementation.

Use Cases

Architecting a scalable multi-tenant database schema for a new SaaS platform.
Refactoring slow-performing legacy SQL queries to reduce server load and latency.
Generating and testing reversible migration scripts for production database updates.