sqlmodel Docker & Self-Hosted Deployment

GitHub

SQL databases in Python, designed for simplicity, compatibility, and robustness.

18,418 stars Python Python 60 files · ~126,947 tokens #fastapi#json#json-schema#pydantic#python#sql#sqlalchemy
RAW Compose
1. Pull Image (DOCKERHUB) docker pull library/postgres
2. Docker Run (1-Click Launch) docker run -d --name sqlmodel -p 15432:15432 --restart always postgres:18
3. Podman Run podman run -d --name sqlmodel -p 15432:15432 --restart always postgres:18
4. Skopeo Inspect (Zero-Pull Manifest) skopeo inspect docker://docker.io/library/postgres:18
5. ORAS Pull (OCI Artifact) oras pull postgres:18
6. Compose Deployment docker compose up -d
compose.yml
Download .yml 
services:
  postgres:
    image: postgres:18
    environment:
      POSTGRES_USER: sqlmodel
      POSTGRES_PASSWORD: sqlmodel
      POSTGRES_DB: sqlmodel_test
    ports:
      - "127.0.0.1:15432:5432"
    healthcheck:
      test: ["CMD", "pg_isready", "-h", "127.0.0.1", "-U", "sqlmodel", "-d", "sqlmodel_test"]
      interval: 2s
      timeout: 5s
      retries: 30

  mysql:
    image: mysql:8.4
    environment:
      MYSQL_ROOT_PASSWORD: sqlmodel
      MYSQL_USER: sqlmodel
      MYSQL_PASSWORD: sqlmodel
      MYSQL_DATABASE: sqlmodel_test
    ports:
      - "127.0.0.1:13306:3306"
    healthcheck:
      test: ["CMD", "mysql", "--host=127.0.0.1", "--user=sqlmodel", "--password=sqlmodel", "--database=sqlmodel_test", "--execute=SELECT 1"]
      interval: 2s
      timeout: 5s
      retries: 30

  mariadb:
    image: mariadb:11.8
    environment:
      MARIADB_ROOT_PASSWORD: sqlmodel
      MARIADB_USER: sqlmodel
      MARIADB_PASSWORD: sqlmodel
      MARIADB_DATABASE: sqlmodel_test
    ports:
      - "127.0.0.1:13307:3306"
    healthcheck:
      test: ["CMD", "healthcheck.sh", "--connect", "--innodb_initialized"]
      interval: 2s
      timeout: 5s
      retries: 30

  adminer:
    image: adminer:5
    profiles: ["debug"]
    ports:
      - "127.0.0.1:18080:8080"