epic-database

Manage Epic Stack databases with Prisma, SQLite, LiteFS migrations and optimization.

Updated May 18, 2026

Search Tags:#query optimization #database #migrations #sqlite #prisma #litefs #epic stack

Ready to run

npx skills add https://github.com/mbdeaton/phys-notes --skill epic-database-mbdeaton

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: epic-database
Source: https://github.com/mbdeaton/phys-notes/tree/main/docs/skills/epic-database
Command: npx skills add https://github.com/mbdeaton/phys-notes --skill epic-database-mbdeaton

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides comprehensive guidance on managing databases within the Epic Stack, covering schema design, migrations, query optimization, and multi-region deployments with SQLite and LiteFS.

Core Features & Use Cases

Database Schema Design: Learn to define models, relationships, and indexes using Prisma.
Migrations & Deployments: Understand how to create and apply migrations, including zero-downtime strategies.
Query Optimization: Implement best practices for efficient data fetching and performance tuning.
Multi-Region Databases: Configure and manage SQLite with LiteFS for distributed applications.

Quick Start

Use the epic-database skill to create a new migration for adding a 'status' field to the 'Note' model.

Frequently Asked Questions about epic-database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I create a zero-downtime database migration in the Epic Stack?▼

To create a zero-downtime database migration in the Epic Stack, use Prisma to generate and apply schema changes while maintaining application availability. This ensures continuous operation during multi-region SQLite deployments.

How does LiteFS work with SQLite for multi-region database deployments?▼

LiteFS distributes SQLite database files across multiple regions to ensure data consistency and synchronization. This allows your Epic Stack application to serve distributed users with low latency and reliable data access.

What is the best way to optimize Prisma queries in the Epic Stack?▼

Optimize Prisma queries in the Epic Stack by designing schemas with appropriate indexes and relationships. This Skill guides you through efficient data fetching practices and performance tuning specifically for SQLite databases.

Can I use Prisma Studio to connect to a production SQLite database via SSH?▼

Yes, you can use Prisma Studio to connect to a production SQLite database via SSH. This Skill covers production deployment considerations, including securely accessing and managing your multi-region LiteFS databases.

How do I configure cascade deletes and CUID2 IDs in a Prisma schema?▼

Configure cascade deletes and CUID2 IDs in a Prisma schema by defining specific relationship rules and ID generation strategies within your models. This ensures data integrity and unique identification across your SQLite database.

What are the limitations of using SQLite with LiteFS for distributed databases?▼

SQLite with LiteFS enables multi-region deployments but presents limitations in managing complex transaction consistency across regions. This Skill addresses constraints by guiding transaction management and schema design precautions.