foundation-database

Set up a relational database layer with schema design, migrations, and connection management.

Updated Mar 26, 2026

Search Tags:#database #migrations #schema #backend-setup #connection-management #environment-config

Ready to run

npx skills add https://github.com/cyberpunk042/devops-expert-local-ai --skill foundation-database

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: foundation-database
Source: https://github.com/cyberpunk042/devops-expert-local-ai/tree/main/.claude/skills/foundation-database
Command: npx skills add https://github.com/cyberpunk042/devops-expert-local-ai --skill foundation-database

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps teams design and implement a scalable relational database layer featuring clean schema, migrations, and robust connection management.

Core Features & Use Cases

Schema design & migrations: Create and evolve database schemas with reversible migrations and seed data for development.
Connection management: Implement pooling, retries, and environment-driven configuration to avoid hard-coded credentials.
Use Case: Apply to projects that require a Postgres/SQLite/MySQL backend with a test database and docker-compose integration.

Quick Start

Run the setup to initialize the database layer with an adapter compatible with your project.

Frequently Asked Questions about foundation-database

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

FAQPage Schema

How do I set up database migrations with reversible schema changes for Postgres or MySQL?▼

Database migrations are set up using an adjustable migration framework that supports reversible schema changes. This allows you to create and evolve relational database schemas with seed data for Postgres, MySQL, or SQLite backends.

What is the best way to manage database connections and avoid hard-coded credentials in a backend application?▼

Connection management is handled through environment-driven configuration, implementing connection pooling and retries. This approach prevents hard-coded credentials by relying on environment-based configuration for safe and scalable database operations.

Does this database setup support multiple relational backends like SQLite and Postgres?▼

Yes, the database layer supports multiple relational backends including Postgres, SQLite, and MySQL. It initializes with an adapter compatible with your project, ensuring a reliable relational backend across different database systems.

How do I configure a test database with seed data for development?▼

A test database with seed data is configured during the schema design and migration setup. This provides development-ready test data alongside a production-ready database layer integrated with docker-compose.

Can I use docker-compose integration for a relational database backend with connection pooling?▼

Yes, docker-compose integration is supported for projects requiring a relational backend. The setup includes proper connection pooling and environment-driven configuration to ensure safe, scalable database operations within your containerized environment.