apitest-mcp

MCP server for testing Oracle → PostgreSQL API migrations.

Give it an API URL — it scans your repo for DB credentials, reads the handler code, fetches valid test data from PG, calls the API, and validates the DB state.

Works with Claude Code and Antigravity.

Install

pip install apitest-mcp

Or from source:

git clone https://github.com/your-org/apitest-mcp
cd apitest-mcp
pip install -e .

Setup

Copy .env.example to .env and fill in your values:

cp .env.example .env

REPO_PATH=/path/to/your/repo
EMP_ID=your_emp_id
AK=your_jwt_token

• REPO_PATH — absolute path to the repo being tested (PHP or Go)
• EMP_ID — your employee ID for API auth
• AK — your JWT token for API auth

Register in Claude Code

claude mcp add apitest-mcp -- python /path/to/apitest-mcp/server.py

Or add to ~/.claude/claude.json:

{
  "mcpServers": {
    "apitest-mcp": {
      "command": "python",
      "args": ["/path/to/apitest-mcp/server.py"],
      "env": {
        "REPO_PATH": "/path/to/your/repo",
        "EMP_ID": "your_emp_id",
        "AK": "your_jwt_token"
      }
    }
  }
}

Register in Antigravity

{
  "mcp_servers": [
    {
      "name": "apitest-mcp",
      "command": "python",
      "args": ["/path/to/apitest-mcp/server.py"],
      "env": {
        "REPO_PATH": "/path/to/your/repo",
        "EMP_ID": "your_emp_id",
        "AK": "your_jwt_token"
      }
    }
  ]
}

Usage

Once registered, just tell Claude:

Test this API: POST http://localhost:8080/erp/preovp/preovpdata

Claude will:

1. Scan repo → find PG credentials
2. Read handler code → understand params + tables
3. Query PG → fetch valid test data
4. Call the API → capture response
5. Validate DB state → report PASS / FAIL

Tools exposed