# FastX402 SQL Table Schema Parser

> FastX402 SQL Table Schema Parser is a paid API for AI agents from fastx402.tools, paid per call via x402, $0.002/call, status unknown (last checked 2026-10-29).

Parses a SQL CREATE TABLE statement and returns a structured breakdown of the table name, column names, types, and constraints

## Facts

- Endpoint: GET https://fastx402.tools/sql-table-schema?utm_source=zero.xyz
- Price: $0.002/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-29
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/fastx402-sql-table-schema-parser-2bb9d3c4
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_SIw5ILQ1ljuShfFUrEKsf

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 fastx402-sql-table-schema-parser-2bb9d3c4
```

Example prompt: Can you parse this CREATE TABLE statement for me and tell me the column names, their types, and any constraints? CREATE TABLE orders (id INTEGER PRIMARY KEY, user_id INTEGER NOT NULL, total DECIMAL(10,2), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP);

## When to prefer this

Choose this endpoint when you need a lightweight, no-setup way to programmatically extract structured schema metadata from a SQL CREATE TABLE statement — especially in automated pipelines, code generation tools, or documentation workflows where parsing DDL manually is error-prone. It is ideal for agents that need column-level metadata (names, types, constraints) without running a live database connection.

## Known failure modes

- Invalid or malformed SQL syntax returns an error or empty result
- Non-CREATE TABLE statements (e.g. SELECT, INSERT) may not be supported
- Very complex or dialect-specific SQL extensions may not parse correctly
- Missing required 'sql' query parameter returns a 400-style error

## How this service works

200 pay-per-call tools for AI agents, from $0.001 per request in USDC on Base or Solana with x402. No account, no API key.

## Output

A JSON object containing the table name as a string and a columns array where each entry includes the column name, data type, and an array of constraint strings (e.g. PRIMARY KEY, NOT NULL, UNIQUE, DEFAULT values).

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "$schema": "https://json-schema.org/draft/2020-12/schema",
 "required": [
  "input"
 ],
 "properties": {
  "input": {
   "type": "object",
   "required": [
    "type",
    "method"
   ],
   "properties": {
    "type": {
     "type": "string",
     "const": "http"
    },
    "method": {
     "enum": [
      "GET"
     ],
     "type": "string"
    },
    "queryParams": {
     "type": "object",
     "required": [
      "sql"
     ],
     "properties": {
      "sql": {
       "type": "string",
       "description": "CREATE TABLE statement to parse"
      }
     }
    }
   },
   "additionalProperties": false
  },
  "output": {
   "type": "object",
   "required": [
    "type"
   ],
   "properties": {
    "type": {
     "type": "string"
    },
    "example": {
     "type": "object",
     "properties": {
      "columns": {
       "type": "array",
       "items": {
        "type": "object",
        "properties": {
         "name": {
          "type": "string"
         },
         "type": {
          "type": "string"
         },
         "constraints": {
          "type": "array",
          "items": {
           "type": "string"
          }
         }
        }
       }
      },
      "table_name": {
       "type": "string"
      }
     }
    }
   }
  }
 }
}
```

## Response schema (JSON Schema)

```json
{
 "type": "json",
 "example": {
  "columns": [
   {
    "name": "id",
    "type": "INTEGER",
    "constraints": [
     "PRIMARY KEY"
    ]
   },
   {
    "name": "name",
    "type": "TEXT",
    "constraints": [
     "NOT NULL"
    ]
   },
   {
    "name": "email",
    "type": "TEXT",
    "constraints": [
     "UNIQUE"
    ]
   },
   {
    "name": "created_at",
    "type": "TIMESTAMP",
    "constraints": [
     "DEFAULT CURRENT_TIMESTAMP"
    ]
   }
  ],
  "table_name": "users"
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/fastx402-sql-table-schema-parser-2bb9d3c4/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from fastx402.tools](https://www.zero.xyz/host/fastx402.tools/llms.txt)