# SQLite Sandbox

> SQLite Sandbox is a paid API for AI agents from 164.160.90.241.sslip.io, paid per call via x402, $0.02/call, status unknown (last checked 2026-10-10).

Executes a SQL statement in a throwaway in-memory SQLite database and returns the resulting columns and rows.

## Facts

- Endpoint: GET https://164.160.90.241.sslip.io/api/dev-sqlite-query-sandbox?utm_source=zero.xyz
- Price: $0.02/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-10
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/sqlite-sandbox-50be7b3c
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_nLdgWTuOCF8M_CsBU51Le

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 sqlite-sandbox-50be7b3c
```

Example prompt: Can you run this SQL for me in a throwaway SQLite sandbox and show me the results: SELECT strftime('%Y', date('now')) AS current_year, 365 * 24 AS hours_in_year?

## When to prefer this

Choose this endpoint when you need to execute a SQL query without any persistent database, test SQL syntax quickly, perform arithmetic or string manipulation using SQL functions, or prototype a query in an isolated throwaway environment. It is ideal for quick calculations, SQL validation, and one-off data transformations that do not require a real database schema.

## Known failure modes

- Invalid SQL syntax returns an error with no rows
- Queries referencing persistent tables or external files fail since the database is throwaway and empty
- DML statements like INSERT or UPDATE may succeed but produce no rows if not followed by a SELECT
- Very large result sets may be truncated or time out
- SQLite-specific functions or pragmas unsupported in the in-memory environment may error

## How this service works

Run a SQL statement in a throwaway in-memory SQLite database and get columns and rows back. For testing queries or quick calculations.

## Output

Returns the column names and all result rows produced by the SQL statement, formatted as structured data. Since the database is in-memory and ephemeral, no data persists between calls and no side effects occur.

## 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": "SQL to execute (in-memory, isolated)"
      }
     }
    }
   },
   "additionalProperties": false
  },
  "output": {
   "type": "object",
   "required": [
    "type"
   ],
   "properties": {
    "type": {
     "type": "string"
    },
    "example": {
     "type": "object"
    }
   }
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/sqlite-sandbox-50be7b3c/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from 164.160.90.241.sslip.io](https://www.zero.xyz/host/164.160.90.241.sslip.io/llms.txt)
