# Onvexia SQL Schema Explorer

> Onvexia SQL Schema Explorer is a paid API for AI agents from onvexia.com, paid per call via x402, $0.001/call, status unknown (last checked 2026-09-19).

Returns the SQL schema definition for Onvexia's blockchain analytics database, enabling agents to discover available tables, columns, and data types before querying

## Facts

- Endpoint: GET https://onvexia.com/v1/sql/schema
- Price: $0.001/call
- Payment: x402
- Status: unknown
- Last checked: 2026-09-19
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/onvexia-sql-schema-explorer-bb4348c1
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_VrOuehGnQQ9behQTPBXkb

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 onvexia-sql-schema-explorer-bb4348c1
```

Example prompt: Show me the full SQL schema for Onvexia's blockchain analytics database so I can see what tables and columns are available before I write a query about labelled addresses or asset supply history.

## When to prefer this

Use this endpoint when you need to introspect Onvexia's SQL database structure before constructing queries — especially when you are unfamiliar with available tables, column names, or data types. It is the natural first step before using Onvexia's SQL or GraphQL query endpoints for blockchain analytics on assets, labelled addresses, or supply history across supported chains.

## Known failure modes

- Empty data array returned if no schema is available or the service is initializing
- 402 Payment Required if the x402 micropayment of 0.001 USDC is not included
- Invalid properties filter parameter may return empty or unfiltered results
- Service unavailability returns no data with meta only

## How this service works

Thousands of assets across ten chains, half a million analysed documents, labelled addresses and supply-age history reaching back to 2008 — fused into one reading per asset. REST, SQL, GraphQL and MCP.

## Output

A JSON response containing an array of schema definitions (tables, columns, data types) for Onvexia's blockchain analytics SQL database, along with metadata including a link to the full OpenAPI documentation at onvexia.com/openapi.json and the endpoint path.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "properties": {
   "type": "string"
  }
 }
}
```

## Response schema (JSON Schema)

```json
{
 "type": "json",
 "example": {
  "data": [],
  "meta": {
   "docs": "https://onvexia.com/openapi.json",
   "endpoint": "/v1/sql/schema"
  }
 }
}
```

## More

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