flaviomagacho/aitosql repository overview

REL-0.3.0 (Git Tag)
    ↓
Gera 3 tags Docker:
    ├─ flaviomagacho/aitosql:latest
    ├─ flaviomagacho/aitosql:0.3.0
    └─ flaviomagacho/aitosql:v0.3.0

# Última versão
docker pull flaviomagacho/aitosql:latest

# Versão específica (recomendado para produção)
docker pull flaviomagacho/aitosql:0.3.0

# O driver JDBC é detectado automaticamente da URL!
docker run -d \
  --name aitosql \
  -e DB_URL="jdbc:postgresql://localhost:5432/mydb" \
  -e DB_USERNAME="readonly_user" \
  -e DB_PASSWORD="secure_password" \
  -p 8080:8080 \
  flaviomagacho/aitosql:0.3.0

version: '3.8'
services:
  aitosql:
    image: flaviomagacho/aitosql:0.3.0
    environment:
      DB_URL: jdbc:postgresql://postgres:5432/mydb
      DB_USERNAME: readonly_user
      DB_PASSWORD: secure_password
      # DB_TYPE não é mais necessário - detectado automaticamente!
    ports:
      - "8080:8080"
    depends_on:
      - postgres
  
  postgres:
    image: postgres:15-alpine
    environment:
      POSTGRES_DB: mydb
      POSTGRES_USER: admin
      POSTGRES_PASSWORD: admin123
    ports:
      - "5432:5432"

version: '3.8'
services:
  aitosql:
    image: flaviomagacho/aitosql:0.3.0
    environment:
      DB_URL: jdbc:mysql://mysql:3306/mydb
      DB_USERNAME: readonly_user
      DB_PASSWORD: secure_password
      # DB_TYPE não é mais necessário - detectado automaticamente!
    ports:
      - "8080:8080"
    depends_on:
      - mysql
  
  mysql:
    image: mysql:8
    environment:
      MYSQL_DATABASE: mydb
      MYSQL_ROOT_PASSWORD: rootpass
      MYSQL_USER: readonly_user
      MYSQL_PASSWORD: secure_password
    ports:
      - "3306:3306"

# ❌ ANTES: Era necessário especificar o driver
docker run -e DB_URL="..." -e DB_TYPE="postgresql" ...

# ✅ AGORA: Driver detectado automaticamente
docker run -e DB_URL="jdbc:postgresql://..." ...

GET http://localhost:8080/actuator/health

GET http://localhost:8080/api/mcp/model-context

POST http://localhost:8080/api/mcp/execute-search
Content-Type: application/json

{
  "sql": "SELECT * FROM users LIMIT 10"
}

GET http://localhost:8080/api/mcp/table-details?tableName=users

GET http://localhost:8080/api/mcp/triggers?tableName=orders

Camadas:
├─ Ubuntu Jammy base: ~30MB
├─ OpenJDK 21: ~200MB
├─ Application JAR: ~50MB
└─ Total comprimido: ~150MB

graph LR
    A[Git Tag REL-X.X.X] --> B[GitHub Actions]
    B --> C[Run Tests]
    C --> D[Generate Coverage Report]
    D --> E[Build Docker Multi-Arch]
    E --> F[Push to Docker Hub]
    F --> G[Create GitHub Release]
    G --> H[Update README]

# Verificar logs
docker logs aitosql

# Verificar conectividade com banco
docker exec -it aitosql curl -s http://localhost:8080/actuator/health

# Listar secrets
gh secret list

# Criar secrets
gh secret set DOCKERHUB_USERNAME --body "magacho"
gh secret set DOCKERHUB_TOKEN --body "seu-token-aqui"