skills.rest
cyberpunk042
cyberpunk042COMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/cyberpunk042/devops-expert-local-ai --skill foundation-database
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
yanun0323yanun0323
1

agents-infra

Enforce governance rules for containerized infrastructure changes affecting runtime interfaces.

Community
Advanced
boparaiamritboparaiamrit
5

database-audit

Audit database schemas, migrations, and data integrity with structured checklists.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
peterbamuhigirepeterbamuhigire
23

android-data-persistence

Standardize Android local storage with Room, DataStore, and Repository pattern.

Community
Advanced