stacks-database

Manage database lifecycle operations for Stacks applications across multiple SQL dialects.

2|Updated Jul 8, 2026
One-click install
npx skills add https://github.com/bughq/bughq --skill stacks-database-bughq
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: stacks-database
Source: https://github.com/bughq/bughq/tree/main/.claude/skills/stacks-database
Command: npx skills add https://github.com/bughq/bughq --skill stacks-database-bughq

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill simplifies complex database operations in Stacks applications, abstracting away the differences between SQLite, MySQL, PostgreSQL, and DynamoDB while providing a unified interface for migrations, seeding, and query building.

Core Features & Use Cases

  • Unified Query Building: Write type-safe queries that work across multiple SQL dialects using a lazy-initialized proxy.
  • Automated Migrations & Seeding: Generate migration diffs, run schema updates, and seed your database with fake data using a single command.
  • Use Case: When you need to add a new table to your application, use this Skill to generate the migration file, apply it to your local development database, and seed it with initial test data.

Quick Start

Use the stacks-database skill to generate a new migration for the users table and then run the migration to update your local database schema.

Frequently Asked Questions about stacks-database

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

FAQPage Schema
How do I run database schema migrations for a TypeScript application?

To run database schema migrations for a TypeScript application, you can generate migration diffs, apply schema updates, and seed data through a single command using a unified configuration interface.

Can I use a single query builder for SQLite, MySQL, PostgreSQL, and DynamoDB?

Yes, you can use a single type-safe query builder for SQLite, MySQL, PostgreSQL, and DynamoDB. It utilizes a lazy-initialized proxy to abstract away dialect differences and execute cross-dialect queries.

What is the best way to generate test data for a local development database?

The best way to generate test data for a local development database is using automated seeding features. You can seed your database with fake data alongside generating migration files and applying schema updates.

Does this database management approach support schema diffing and connection pooling?

Yes, this database management approach supports schema diffing and connection pooling. It facilitates these maintenance tasks alongside automated migrations and entity-centric data access across multiple SQL dialects.

How do I add a new table and update my database schema?

To add a new table and update your database schema, you can generate a new migration file for the specific table and then run the migration to apply the schema update to your local database.

When do I need to use a unified database configuration interface?

You need to use a unified database configuration interface when managing cross-dialect query execution for Stacks applications, allowing you to abstract differences between SQLite, MySQL, PostgreSQL, and DynamoDB.