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.

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

01Advanced query optimization including indexing strategies and EXPLAIN ANALYZE interpretation.

021 GitHub stars

03Safe migration planning focusing on atomicity, reversibility, and zero-downtime practices.

04Implementation of common data patterns such as soft deletes and complex join structures.

05Schema design optimization using 1NF, 2NF, and 3NF normalization standards.

06Comprehensive ORM support for Prisma, TypeORM, and SQLAlchemy implementation.

Use Cases

01Architecting a scalable multi-tenant database schema for a new SaaS platform.

02Refactoring slow-performing legacy SQL queries to reduce server load and latency.

03Generating and testing reversible migration scripts for production database updates.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add always-further/claude-extensions database-assistant

For use in Claude.ai and ChatGPT

Download Skill