# apiacre.com SQL Change Review

> apiacre.com SQL Change Review is a paid API for AI agents from apiacre.com, paid per call via x402, $0.05/call, status unknown (last checked 2026-10-09).

Statically analyzes caller-supplied SQL statements without executing them, inventorying tables and operations while flagging destructive DDL, unfiltered writes, and migration atomicity risks.

## Facts

- Endpoint: POST https://apiacre.com/v1/developer/sql-change-review?utm_source=zero.xyz
- Price: $0.05/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-09
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/apiacre-com-sql-change-review-ae67cf0e
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_RggOPPCVqjUq1xfR3h4No

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability apiacre-com-sql-change-review-ae67cf0e -d '<json body>'
```

Example prompt: Can you statically review this SQL migration script for me — flag any destructive DDL like DROP or TRUNCATE, unfiltered UPDATE or DELETE statements, and any atomicity concerns, without actually running it against a database?

## When to prefer this

Choose this endpoint when you need a safe, zero-side-effect pre-flight check on SQL before execution — especially for migration scripts, CI/CD pipelines, or code review automation. It is ideal when you cannot or should not connect to a live database, and you want structured, machine-readable risk flags rather than a human-written opinion. Prefer it over running EXPLAIN or database-native checks when isolation from the database is required.

## Known failure modes

- Malformed or unparseable SQL returns a parse error with position details
- Extremely large or complex SQL scripts may exceed input size limits
- Dialect-specific syntax unsupported by the static parser may produce incomplete analysis
- Ambiguous or dynamic SQL (e.g. using variables) may not be fully analyzable statically

## How this service works

Statically parse caller-supplied SQL without a database connection or execution, inventory statements and tables, and flag destructive DDL, unfiltered writes, and migration atomicity concerns.

## Output

Returns a structured report including an inventory of parsed SQL statements and affected tables, flags for destructive DDL operations (e.g. DROP, TRUNCATE), warnings about unfiltered writes (UPDATE or DELETE without WHERE clauses), and atomicity concerns in migration scripts — all without executing the SQL against any database.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "sql": {
   "type": "string"
  },
  "dialect": {
   "enum": [
    "postgres",
    "mysql",
    "sqlite",
    "tsql",
    "bigquery",
    "snowflake",
    "duckdb",
    "spark",
    "oracle",
    "redshift"
   ],
   "type": "string"
  }
 }
}
```

## Response schema (JSON Schema)

```json
{
 "type": "json",
 "example": {
  "data": {
   "valid": true,
   "parser": {
    "name": "SQLGlot",
    "license": "MIT",
    "version": "30.16.0"
   },
   "dialect": "postgres",
   "summary": {
    "readStatements": 0,
    "otherStatements": 0,
    "dataChangeStatements": 0,
    "transactionStatements": 0,
    "schemaChangeStatements": 1
   },
   "findings": [],
   "execution": {
    "sqlExecuted": false,
    "databaseConnected": false
   },
   "statements": [
    {
     "index": 1,
     "category": "schema-change",
     "readOnly": false,
     "operation": "CREATE",
     "targetObjects": [
      "accounts"
     ]
    }
   ],
   "limitations": [
    "Static syntax review only; database schema, permissions, triggers, data volum...",
    "A low attention score does not prove a change is correct or safe to deploy."
   ],
   "attentionLevel": "clear",
   "attentionScore": 0,
   "documentSha256": "3e31b98c852573137d17dcb062b2a1571d63052f71abeeb8b62296f3d1066af4",
   "reviewDecision": "clear",
   "statementCount": 1
  },
  "meta": {
   "cached": false,
   "sources": [],
   "warnings": [],
   "duration_ms": 42,
   "next_actions": []
  },
  "service": "developer.sql-change-review",
  "version": "1",
  "request_id": "018f1f54-7f38-7ba2-8dc3-5f90272d9f1a"
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/apiacre-com-sql-change-review-ae67cf0e/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from apiacre.com](https://www.zero.xyz/host/apiacre.com/llms.txt)