Configure PostgreSQL connections and schema setup for FastAPI projects.
npx skills add https://github.com/databio/ai-sandbox --skill database-guide
Please help me install this Agent Skill. Skill: database-guide Source: https://github.com/databio/ai-sandbox/tree/main/workspaces/.claude/skills/database-guide Command: npx skills add https://github.com/databio/ai-sandbox --skill database-guide
Set up and manage PostgreSQL databases for FastAPI projects with a Docker-based local development workflow (single-command, no docker-compose) and production-ready configurations using environment variables. It follows a no-migrations philosophy, dropping and recreating the schema on changes, and provides guidance for setup_postgres.sh scripts, environment files that must be sourced manually, pydantic-settings configuration, SQLModel connections, lifespan handlers, session management, and Pytest-based tests using in-memory SQLite.
Source deployment/demo.env to load local Postgres credentials and start the FastAPI app to create tables on startup.
High-intent search queries and answers about installing and using this skill.
PostgreSQL setup for FastAPI with Docker is automated using a setup_postgres.sh script, enabling a single-command local development workflow without needing docker-compose. You must source your environment file to load credentials before starting the application to create tables on startup.
Database schema changes in FastAPI are handled using a no-migrations policy that drops and recreates the schema on changes. This approach is paired with a startup lifespan handler that automatically creates tables when the application launches.
FastAPI testing uses in-memory SQLite for fast Pytest-based tests in CI environments. This allows you to test endpoints locally without the overhead of a running PostgreSQL instance, while production uses environment-based configuration.
Environment files must be sourced manually to configure the FastAPI PostgreSQL connection in production. The setup relies on pydantic-settings configuration, meaning you source deployment/*.env files to load local Postgres credentials before running the application.
SQLModel integration in a FastAPI app involves configuring database connections and handling session management within startup lifespan handlers. This approach manages schema creation and sessions seamlessly alongside the no-migrations drop-and-recreate policy.
FastAPI PostgreSQL database setup scripts fail to connect if environment files are not sourced manually before running. You must source deployment/demo.env to load local Postgres credentials into the environment for the application to establish a valid connection.
etendosoftwareInitialize an Etendo ERP project by cloning etendo_base and configuring gradle.properties.
saintgo7Configure deterministic FastAPI pytest integration tests with httpx ASGITransport and respx mocking.
kobikisWrite pytest-asyncio tests for FastAPI endpoints using AsyncClient and fixtures.
NelkitAutomate PostgreSQL schema changes with SQLAlchemy ORM and Alembic migrations.
