A lightweight CockroachDB Docker image optimized for CI/CD pipelines and functional testing. This image extends the official CockroachDB Docker image with automatic single-node startup, optional database creation, and performance optimizations for testing environments.

✅ Automatic startup - CockroachDB starts immediately in single-node mode
✅ Database creation - Optionally creates a named database on startup
✅ In-memory storage - Configurable in-memory storage for faster tests
✅ Security hardened - Runs as non-root user with health checks
✅ CI/CD optimized - Perfect for GitHub Actions service containers
✅ Multi-platform - Supports both AMD64 and ARM64 architectures

# Run with default settings
docker run -d -p 8080:8080 -p 26257:26257 timveil/cockroachdb-single-node:latest

# Access CockroachDB Admin UI
open http://localhost:8080

# Connect with SQL client
docker exec -it <container_id> /cockroach/cockroach sql --insecure

docker run -d -p 8080:8080 -p 26257:26257 \
  -e "DATABASE_NAME=myapp" \
  -e "MEMORY_SIZE=1" \
  timveil/cockroachdb-single-node:latest

Perfect for use as a service container in GitHub Actions workflows:

name: Tests
on: [push, pull_request]

jobs:
  test:
    runs-on: ubuntu-latest
    services:
      cockroach:
        image: timveil/cockroachdb-single-node:latest
        env:
          DATABASE_NAME: testdb
          MEMORY_SIZE: 0.5
        ports:
          - 26257:26257
        options: >-
          --health-cmd="/cockroach/cockroach sql --insecure --execute='SELECT 1'"
          --health-interval=10s
          --health-timeout=5s
          --health-retries=5

    steps:
      - uses: actions/checkout@v4
      - name: Run tests
        run: |
          # Your test commands here
          # CockroachDB is available at localhost:26257

The image is automatically built and published to Docker Hub with multiple tags:

This image includes several CockroachDB settings optimized for testing environments:

• Disabled raft log synchronization - Faster writes in test scenarios
• Reduced job intervals - Quicker background job execution
• Shortened GC TTL - Faster cleanup of deleted data
• Disabled automatic stats - Reduces background overhead

⚠️ Note: These optimizations prioritize speed over durability and are intended for testing only.

# Clone the repository
git clone https://github.com/timveil-cockroach/cockroachdb-single-node.git
cd cockroachdb-single-node

# Build the image
docker build --no-cache -t cockroachdb-single-node:local .

# Run locally built image
docker run -d -p 8080:8080 -p 26257:26257 cockroachdb-single-node:local

The image consists of four key components:

• Dockerfile - Security-hardened container with health checks
• init.sh - Entry point script that configures and starts CockroachDB
• optimizations.sql - Performance tuning for test environments
• logs.yaml - Structured logging configuration

The image includes built-in health checks that verify CockroachDB is responding:

# Check container health
docker ps --filter "health=healthy"

# Manual health check
docker exec <container_id> /cockroach/cockroach sql --insecure --execute="SELECT 1"

Contributions are welcome! Please see our GitHub Actions workflows for CI/CD processes.

This project is licensed under the Apache License 2.0 - see the CockroachDB license for details.