postgres-mcp

name: CI on: push: branches: [main] pull_request: branches: [main] jobs: test: runs-on: ubuntu-latest strategy: matrix: python-version: ["3.10", "3.11", "3.12"] services: postgres: image: postgres:16 env: POSTGRES_USER: test POSTGRES_PASSWORD: test POSTGRES_DB: test ports: - 5432:5432 options: >- --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5 steps: - uses: actions/checkout@v4 - name: Install uv uses: astral-sh/setup-uv@v4 - name: Set up Python ${{ matrix.python-version }} run: uv python install ${{ matrix.python-version }} - name: Install dependencies run: uv sync --dev - name: Load sample data into PostgreSQL env: PGPASSWORD: test run: psql -h localhost -U test -d test -f scripts/init_sample_db.sql - name: Run tests with coverage env: POSTGRES_HOST: localhost POSTGRES_PORT: 5432 POSTGRES_USER: test POSTGRES_PASSWORD: test POSTGRES_DB: test run: uv run pytest -v --cov=postgres_mcp --cov-report=term-missing --cov-report=xml - name: Upload coverage to Codecov if: matrix.python-version == '3.12' uses: codecov/codecov-action@v4 with: files: ./coverage.xml fail_ci_if_error: false lint: runs-on: ubuntu-latest steps: - uses: actions/checkout@v4 - name: Install uv uses: astral-sh/setup-uv@v4 - name: Set up Python run: uv python install 3.12 - name: Install dependencies run: uv sync --dev - name: Check formatting with ruff run: uv run ruff format --check . continue-on-error: true - name: Lint with ruff run: uv run ruff check . continue-on-error: true build: runs-on: ubuntu-latest needs: test steps: - uses: actions/checkout@v4 - name: Install uv uses: astral-sh/setup-uv@v4 - name: Build package run: uv build - name: Upload artifacts uses: actions/upload-artifact@v4 with: name: dist path: dist/