Managed database

Managed Postgres: provision projects, copy-on-write branches and point-in-time snapshots across Neon / Supabase / PlanetScale.

Overview

Base path: https://api.infrai.cc/v1/db

Auth header: Authorization: Bearer $INFRAI_API_KEY

bash

# Call any /v1/db capability over raw HTTP — no SDK to install.
# curl:
curl https://api.infrai.cc/v1/db/... \
  -H "Authorization: Bearer $INFRAI_API_KEY" \
  -H "Content-Type: application/json"

Methods

db.project.create

POST /v1/db/project/create

Provision a managed Postgres project on the selected vendor (Neon/Supabase/PlanetScale).

Parameters

Name	Type	Required	Description
`name`	`string`	Required	Database project name.
`vendor`	`string`	Optional	Explicit vendor pin; required when mode=byok.
`region`	`string`	Optional	Region to provision in.
`plan`	`string`	Optional	Provisioning plan / size.
`mode`	`"managed" \| "byok"`	Optional	Provisioning mode — managed or byok.
`postgres_version`	`string`	Optional	Postgres major version.
`idempotency_key`	`string`	Optional	Client-supplied key to make the call idempotent.

Returns

Project { id, name, region, connection_uri, created_at }

Example

一次性前置(每个范例都假定已完成):

bash

# No SDK to install — every call is a plain HTTPS request.
# Get a project key by signing in at the console: Google/GitHub gives you
# $2 free credit (email sign-in starts at $0). On 402 INSUFFICIENT_CREDIT,
# POST /v1/account/topup and open the returned checkout_url.
export INFRAI_API_KEY="ifr_pk_proj_..."

bash

curl -X POST https://api.infrai.cc/v1/db/project/create \
  -H "Authorization: Bearer $INFRAI_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"name": "..."}'

python

import os, requests

resp = requests.post(
    "https://api.infrai.cc/v1/db/project/create",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
    json={'name': '...'},
)
resp.raise_for_status()
print(resp.json())

javascript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/project/create",
  {
    method: "POST",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
      "Content-Type": "application/json",
    },
    body: JSON.stringify({"name": "..."}),
  },
);
console.log(await resp.json());

typescript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/project/create",
  {
    method: "POST",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
      "Content-Type": "application/json",
    },
    body: JSON.stringify({"name": "..."}),
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

db.project.get

GET /v1/db/project/get/{id}

Fetch a managed database project by id, including its connection URI.

Parameters

Name	Type	Required	Description
`id`	`string`	Required	The project id.

Returns

Project

Example

一次性前置(每个范例都假定已完成):

bash

# No SDK to install — every call is a plain HTTPS request.
# Get a project key by signing in at the console: Google/GitHub gives you
# $2 free credit (email sign-in starts at $0). On 402 INSUFFICIENT_CREDIT,
# POST /v1/account/topup and open the returned checkout_url.
export INFRAI_API_KEY="ifr_pk_proj_..."

bash

curl -X GET https://api.infrai.cc/v1/db/project/get/ID \
  -H "Authorization: Bearer $INFRAI_API_KEY"

python

import os, requests

resp = requests.get(
    "https://api.infrai.cc/v1/db/project/get/ID",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
)
resp.raise_for_status()
print(resp.json())

javascript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/project/get/ID",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
console.log(await resp.json());

typescript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/project/get/ID",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

db.project.list

GET /v1/db/project/list

List the managed database projects for the account.

Parameters

Name	Type	Required	Description
`cursor`	`string`	Optional	Opaque pagination cursor.
`limit`	`number`	Optional	Maximum number of items to return.

Returns

{ items: Project[], next_cursor?: string }

Example

一次性前置(每个范例都假定已完成):

bash

# No SDK to install — every call is a plain HTTPS request.
# Get a project key by signing in at the console: Google/GitHub gives you
# $2 free credit (email sign-in starts at $0). On 402 INSUFFICIENT_CREDIT,
# POST /v1/account/topup and open the returned checkout_url.
export INFRAI_API_KEY="ifr_pk_proj_..."

bash

curl -X GET https://api.infrai.cc/v1/db/project/list \
  -H "Authorization: Bearer $INFRAI_API_KEY"

python

import os, requests

resp = requests.get(
    "https://api.infrai.cc/v1/db/project/list",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
)
resp.raise_for_status()
print(resp.json())

javascript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/project/list",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
console.log(await resp.json());

typescript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/project/list",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

db.project.delete

DELETE /v1/db/project/delete/{id}

Delete a managed database project and all its branches/snapshots.

Parameters

Name	Type	Required	Description
`id`	`string`	Required	The project id.

Returns

{ ok: boolean }

Example

一次性前置(每个范例都假定已完成):

bash

# No SDK to install — every call is a plain HTTPS request.
# Get a project key by signing in at the console: Google/GitHub gives you
# $2 free credit (email sign-in starts at $0). On 402 INSUFFICIENT_CREDIT,
# POST /v1/account/topup and open the returned checkout_url.
export INFRAI_API_KEY="ifr_pk_proj_..."

bash

curl -X DELETE https://api.infrai.cc/v1/db/project/delete/ID \
  -H "Authorization: Bearer $INFRAI_API_KEY"

python

import os, requests

resp = requests.delete(
    "https://api.infrai.cc/v1/db/project/delete/ID",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
)
resp.raise_for_status()
print(resp.json())

javascript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/project/delete/ID",
  {
    method: "DELETE",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
console.log(await resp.json());

typescript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/project/delete/ID",
  {
    method: "DELETE",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

db.branch.create

POST /v1/db/branch/create

Create a copy-on-write branch of a project for previews or testing.

Parameters

Name	Type	Required	Description
`project_id`	`string`	Required	The project id.
`branch_name`	`string`	Required	Name for the new branch.
`from_branch`	`string`	Optional	Source branch to clone from.
`idempotency_key`	`string`	Optional	Client-supplied key to make the call idempotent.

Returns

Branch { id, branch_name, project_id, connection_uri }

Example

一次性前置(每个范例都假定已完成):

bash

# No SDK to install — every call is a plain HTTPS request.
# Get a project key by signing in at the console: Google/GitHub gives you
# $2 free credit (email sign-in starts at $0). On 402 INSUFFICIENT_CREDIT,
# POST /v1/account/topup and open the returned checkout_url.
export INFRAI_API_KEY="ifr_pk_proj_..."

bash

curl -X POST https://api.infrai.cc/v1/db/branch/create \
  -H "Authorization: Bearer $INFRAI_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"project_id": "...", "branch_name": "..."}'

python

import os, requests

resp = requests.post(
    "https://api.infrai.cc/v1/db/branch/create",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
    json={'project_id': '...', 'branch_name': '...'},
)
resp.raise_for_status()
print(resp.json())

javascript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/branch/create",
  {
    method: "POST",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
      "Content-Type": "application/json",
    },
    body: JSON.stringify({"project_id": "...", "branch_name": "..."}),
  },
);
console.log(await resp.json());

typescript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/branch/create",
  {
    method: "POST",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
      "Content-Type": "application/json",
    },
    body: JSON.stringify({"project_id": "...", "branch_name": "..."}),
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

db.branch.get

GET /v1/db/branch/get/{id}

Fetch a database branch by id, including its connection URI.

Parameters

Name	Type	Required	Description
`id`	`string`	Required	The branch id.

Returns

Branch

Example

一次性前置(每个范例都假定已完成):

bash

# No SDK to install — every call is a plain HTTPS request.
# Get a project key by signing in at the console: Google/GitHub gives you
# $2 free credit (email sign-in starts at $0). On 402 INSUFFICIENT_CREDIT,
# POST /v1/account/topup and open the returned checkout_url.
export INFRAI_API_KEY="ifr_pk_proj_..."

bash

curl -X GET https://api.infrai.cc/v1/db/branch/get/ID \
  -H "Authorization: Bearer $INFRAI_API_KEY"

python

import os, requests

resp = requests.get(
    "https://api.infrai.cc/v1/db/branch/get/ID",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
)
resp.raise_for_status()
print(resp.json())

javascript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/branch/get/ID",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
console.log(await resp.json());

typescript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/branch/get/ID",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

db.branch.list

GET /v1/db/branch/list

List the branches of a managed database project.

Parameters

Name	Type	Required	Description
`project_id`	`string`	Optional	The project id.
`cursor`	`string`	Optional	Opaque pagination cursor.
`limit`	`number`	Optional	Maximum number of items to return.

Returns

{ items: Branch[], next_cursor?: string }

Example

一次性前置(每个范例都假定已完成):

bash

# No SDK to install — every call is a plain HTTPS request.
# Get a project key by signing in at the console: Google/GitHub gives you
# $2 free credit (email sign-in starts at $0). On 402 INSUFFICIENT_CREDIT,
# POST /v1/account/topup and open the returned checkout_url.
export INFRAI_API_KEY="ifr_pk_proj_..."

bash

curl -X GET https://api.infrai.cc/v1/db/branch/list \
  -H "Authorization: Bearer $INFRAI_API_KEY"

python

import os, requests

resp = requests.get(
    "https://api.infrai.cc/v1/db/branch/list",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
)
resp.raise_for_status()
print(resp.json())

javascript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/branch/list",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
console.log(await resp.json());

typescript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/branch/list",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

db.branch.delete

DELETE /v1/db/branch/delete/{id}

Delete a database branch.

Parameters

Name	Type	Required	Description
`id`	`string`	Required	The branch id.

Returns

{ ok: boolean }

Example

一次性前置(每个范例都假定已完成):

bash

# No SDK to install — every call is a plain HTTPS request.
# Get a project key by signing in at the console: Google/GitHub gives you
# $2 free credit (email sign-in starts at $0). On 402 INSUFFICIENT_CREDIT,
# POST /v1/account/topup and open the returned checkout_url.
export INFRAI_API_KEY="ifr_pk_proj_..."

bash

curl -X DELETE https://api.infrai.cc/v1/db/branch/delete/ID \
  -H "Authorization: Bearer $INFRAI_API_KEY"

python

import os, requests

resp = requests.delete(
    "https://api.infrai.cc/v1/db/branch/delete/ID",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
)
resp.raise_for_status()
print(resp.json())

javascript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/branch/delete/ID",
  {
    method: "DELETE",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
console.log(await resp.json());

typescript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/branch/delete/ID",
  {
    method: "DELETE",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

db.snapshot.create

POST /v1/db/snapshot/create

Take a point-in-time snapshot of a managed database project.

Parameters

Name	Type	Required	Description
`project_id`	`string`	Required	The project id.
`label`	`string`	Optional	Human-readable snapshot label.
`idempotency_key`	`string`	Optional	Client-supplied key to make the call idempotent.

Returns

Snapshot { id, project_id, label?, created_at }

Example

一次性前置(每个范例都假定已完成):

bash

# No SDK to install — every call is a plain HTTPS request.
# Get a project key by signing in at the console: Google/GitHub gives you
# $2 free credit (email sign-in starts at $0). On 402 INSUFFICIENT_CREDIT,
# POST /v1/account/topup and open the returned checkout_url.
export INFRAI_API_KEY="ifr_pk_proj_..."

bash

curl -X POST https://api.infrai.cc/v1/db/snapshot/create \
  -H "Authorization: Bearer $INFRAI_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"project_id": "..."}'

python

import os, requests

resp = requests.post(
    "https://api.infrai.cc/v1/db/snapshot/create",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
    json={'project_id': '...'},
)
resp.raise_for_status()
print(resp.json())

javascript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/snapshot/create",
  {
    method: "POST",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
      "Content-Type": "application/json",
    },
    body: JSON.stringify({"project_id": "..."}),
  },
);
console.log(await resp.json());

typescript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/snapshot/create",
  {
    method: "POST",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
      "Content-Type": "application/json",
    },
    body: JSON.stringify({"project_id": "..."}),
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

db.snapshot.get

GET /v1/db/snapshot/get/{id}

Fetch a database snapshot by id.

Parameters

Name	Type	Required	Description
`id`	`string`	Required	The snapshot id.

Returns

Snapshot

Example

一次性前置(每个范例都假定已完成):

bash

# No SDK to install — every call is a plain HTTPS request.
# Get a project key by signing in at the console: Google/GitHub gives you
# $2 free credit (email sign-in starts at $0). On 402 INSUFFICIENT_CREDIT,
# POST /v1/account/topup and open the returned checkout_url.
export INFRAI_API_KEY="ifr_pk_proj_..."

bash

curl -X GET https://api.infrai.cc/v1/db/snapshot/get/ID \
  -H "Authorization: Bearer $INFRAI_API_KEY"

python

import os, requests

resp = requests.get(
    "https://api.infrai.cc/v1/db/snapshot/get/ID",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
)
resp.raise_for_status()
print(resp.json())

javascript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/snapshot/get/ID",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
console.log(await resp.json());

typescript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/snapshot/get/ID",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

db.snapshot.list

GET /v1/db/snapshot/list

List the snapshots of a managed database project.

Parameters

Name	Type	Required	Description
`project_id`	`string`	Optional	The project id.
`cursor`	`string`	Optional	Opaque pagination cursor.
`limit`	`number`	Optional	Maximum number of items to return.

Returns

{ items: Snapshot[], next_cursor?: string }

Example

一次性前置(每个范例都假定已完成):

bash

# No SDK to install — every call is a plain HTTPS request.
# Get a project key by signing in at the console: Google/GitHub gives you
# $2 free credit (email sign-in starts at $0). On 402 INSUFFICIENT_CREDIT,
# POST /v1/account/topup and open the returned checkout_url.
export INFRAI_API_KEY="ifr_pk_proj_..."

bash

curl -X GET https://api.infrai.cc/v1/db/snapshot/list \
  -H "Authorization: Bearer $INFRAI_API_KEY"

python

import os, requests

resp = requests.get(
    "https://api.infrai.cc/v1/db/snapshot/list",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
)
resp.raise_for_status()
print(resp.json())

javascript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/snapshot/list",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
console.log(await resp.json());

typescript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/snapshot/list",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

db.snapshot.restore

POST /v1/db/snapshot/restore/{id}

Restore a snapshot into a new managed database project.

Parameters

Name	Type	Required	Description
`snapshot_id`	`string`	Required	The snapshot id.
`new_name`	`string`	Optional	Name for the restored project (defaults to the source name with a -restored suffix).
`idempotency_key`	`string`	Optional	Client-supplied key to make the call idempotent.

Returns

Project { id, name, connection_uri }

Example

一次性前置(每个范例都假定已完成):

bash

# No SDK to install — every call is a plain HTTPS request.
# Get a project key by signing in at the console: Google/GitHub gives you
# $2 free credit (email sign-in starts at $0). On 402 INSUFFICIENT_CREDIT,
# POST /v1/account/topup and open the returned checkout_url.
export INFRAI_API_KEY="ifr_pk_proj_..."

bash

curl -X POST https://api.infrai.cc/v1/db/snapshot/restore/ID \
  -H "Authorization: Bearer $INFRAI_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"snapshot_id": "..."}'

python

import os, requests

resp = requests.post(
    "https://api.infrai.cc/v1/db/snapshot/restore/ID",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
    json={'snapshot_id': '...'},
)
resp.raise_for_status()
print(resp.json())

javascript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/snapshot/restore/ID",
  {
    method: "POST",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
      "Content-Type": "application/json",
    },
    body: JSON.stringify({"snapshot_id": "..."}),
  },
);
console.log(await resp.json());

typescript

const resp = await fetch(
  "https://api.infrai.cc/v1/db/snapshot/restore/ID",
  {
    method: "POST",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
      "Content-Type": "application/json",
    },
    body: JSON.stringify({"snapshot_id": "..."}),
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

Advanced: pin a vendor

By default infrai routes each call to the best available provider — you do not pick a vendor. As an escape hatch, this capability accepts an optional vendor parameter to pin one specific provider. Every live vendor for this capability is available in real time from the discovery endpoint for the capability id — see the discovery API.

GET /v1/discovery/{capability}

db.project.create

All capabilities

Every routed capability in this module — the complete public REST contract. The methods above are the guided walkthrough; this index is the full reference.

Capability	Endpoint	Description
`db.branch.create`	`POST /v1/db/branch/create`	db branch create — managed database (Neon/Supabase/PlanetScale).
`db.branch.delete`	`DELETE /v1/db/branch/delete/{id}`	db branch delete — managed database (Neon/Supabase/PlanetScale).
`db.branch.get`	`GET /v1/db/branch/get/{id}`	db branch get — managed database (Neon/Supabase/PlanetScale).
`db.branch.list`	`GET /v1/db/branch/list`	db branch list — managed database (Neon/Supabase/PlanetScale).
`db.project.create`	`POST /v1/db/project/create`	db project create — managed database (Neon/Supabase/PlanetScale).
`db.project.delete`	`DELETE /v1/db/project/delete/{id}`	db project delete — managed database (Neon/Supabase/PlanetScale).
`db.project.get`	`GET /v1/db/project/get/{id}`	db project get — managed database (Neon/Supabase/PlanetScale).
`db.project.list`	`GET /v1/db/project/list`	db project list — managed database (Neon/Supabase/PlanetScale).
`db.snapshot.create`	`POST /v1/db/snapshot/create`	db snapshot create — managed database (Neon/Supabase/PlanetScale).
`db.snapshot.get`	`GET /v1/db/snapshot/get/{id}`	db snapshot get — managed database (Neon/Supabase/PlanetScale).
`db.snapshot.list`	`GET /v1/db/snapshot/list`	db snapshot list — managed database (Neon/Supabase/PlanetScale).
`db.snapshot.restore`	`POST /v1/db/snapshot/restore/{id}`	db snapshot restore — managed database (Neon/Supabase/PlanetScale).

End-to-end example

A production-style walkthrough of this module: configure once, then run the flow. It exercises most of the module's APIs.

A copy-paste-runnable single-file Python program (stdlib only, no SDK): set your INFRAI_API_KEY, run it, and walk this module's core flow with REAL billed calls — later steps reuse real fields returned by earlier ones. The 12-line helper is the entire integration.

python

#!/usr/bin/env python3
"""Infrai · db — runnable real-app example (single file, zero deps).

Copy this file, set your key, run it: every step is a REAL call to
api.infrai.cc, billed at the real (tiny) per-call price, printing the
live JSON response. Get a key at https://console.infrai.cc (Google/
GitHub sign-in grants $2 free credit). No SDK — the 12-line helper
below is the entire integration."""
import json
import os
from urllib import error, request

KEY = os.environ.get("INFRAI_API_KEY") or "ifr_pk_proj_..."  # <- your key
BASE = "https://api.infrai.cc"


# Same raw HTTPS POST/GET as every per-method example on this page —
# wrapped once for reuse. There is nothing else to it: no SDK.
def infrai(method, path, body=None):
    req = request.Request(
        BASE + path, method=method,
        data=json.dumps(body).encode() if body is not None else None,
        headers={"Authorization": f"Bearer {KEY}",
                 "Content-Type": "application/json"})
    try:
        with request.urlopen(req, timeout=60) as r:
            return json.loads(r.read())
    except error.HTTPError as e:
        return json.loads(e.read())


def show(label, resp):
    print(f"\n== {label} ==")
    print(json.dumps(resp, indent=2, ensure_ascii=False))
    return resp


# 1) db.project.create — POST /v1/db/project/create · db project create — managed database (Neon/Supabase/PlanetScale).
r1 = show("db.project.create", infrai("POST", "/v1/db/project/create", {"name":"..."}))

# 2) db.branch.create — POST /v1/db/branch/create · db branch create — managed database (Neon/Supabase/PlanetScale).
r2 = show("db.branch.create", infrai("POST", "/v1/db/branch/create", {"project_id":"...","branch_name":"..."}))

# 3) db.project.list — GET /v1/db/project/list · db project list — managed database (Neon/Supabase/PlanetScale).
r3 = show("db.project.list", infrai("GET", "/v1/db/project/list"))

一次性前置(每个范例都假定已完成):

bash

# No SDK to install — every call is a plain HTTPS request.
# Get a project key by signing in at the console: Google/GitHub gives you
# $2 free credit (email sign-in starts at $0). On 402 INSUFFICIENT_CREDIT,
# POST /v1/account/topup and open the returned checkout_url.
export INFRAI_API_KEY="ifr_pk_proj_..."

bash

# 1) Auth: every call is a raw HTTPS request to the Infrai gateway carrying
#    only your project key. No SDK, no install.
#    Get your key: sign in with Google/GitHub at the console for a project key
#    + $2 free credit (email sign-in starts at $0). On 402 INSUFFICIENT_CREDIT,
#    POST /v1/account/topup and open the returned checkout_url.
export INFRAI_API_KEY="ifr_pk_proj_..."   # from the console


# 2) db.project.create
curl -X POST https://api.infrai.cc/v1/db/project/create \
  -H "Authorization: Bearer $INFRAI_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"name": "..."}'

# 3) db.project.get
curl -X GET https://api.infrai.cc/v1/db/project/get/ID \
  -H "Authorization: Bearer $INFRAI_API_KEY"

# 4) db.project.list
curl -X GET https://api.infrai.cc/v1/db/project/list \
  -H "Authorization: Bearer $INFRAI_API_KEY"

# 5) db.project.delete
curl -X DELETE https://api.infrai.cc/v1/db/project/delete/ID \
  -H "Authorization: Bearer $INFRAI_API_KEY"

# 6) db.branch.create
curl -X POST https://api.infrai.cc/v1/db/branch/create \
  -H "Authorization: Bearer $INFRAI_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"project_id": "...", "branch_name": "..."}'

# 7) db.branch.get
curl -X GET https://api.infrai.cc/v1/db/branch/get/ID \
  -H "Authorization: Bearer $INFRAI_API_KEY"

# 8) db.branch.list
curl -X GET https://api.infrai.cc/v1/db/branch/list \
  -H "Authorization: Bearer $INFRAI_API_KEY"

# 9) db.branch.delete
curl -X DELETE https://api.infrai.cc/v1/db/branch/delete/ID \
  -H "Authorization: Bearer $INFRAI_API_KEY"

python

# 1) Auth: every call is a raw HTTPS request carrying only your project key.
#    No SDK to install — just the `requests` library.
import os, requests

BASE = "https://api.infrai.cc"
HEADERS = {
    "Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}",
    "Content-Type": "application/json",
}


# 2) db.project.create
import os, requests

resp = requests.post(
    "https://api.infrai.cc/v1/db/project/create",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
    json={'name': '...'},
)
resp.raise_for_status()
print(resp.json())

# 3) db.project.get
import os, requests

resp = requests.get(
    "https://api.infrai.cc/v1/db/project/get/ID",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
)
resp.raise_for_status()
print(resp.json())

# 4) db.project.list
import os, requests

resp = requests.get(
    "https://api.infrai.cc/v1/db/project/list",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
)
resp.raise_for_status()
print(resp.json())

# 5) db.project.delete
import os, requests

resp = requests.delete(
    "https://api.infrai.cc/v1/db/project/delete/ID",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
)
resp.raise_for_status()
print(resp.json())

# 6) db.branch.create
import os, requests

resp = requests.post(
    "https://api.infrai.cc/v1/db/branch/create",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
    json={'project_id': '...', 'branch_name': '...'},
)
resp.raise_for_status()
print(resp.json())

# 7) db.branch.get
import os, requests

resp = requests.get(
    "https://api.infrai.cc/v1/db/branch/get/ID",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
)
resp.raise_for_status()
print(resp.json())

# 8) db.branch.list
import os, requests

resp = requests.get(
    "https://api.infrai.cc/v1/db/branch/list",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
)
resp.raise_for_status()
print(resp.json())

# 9) db.branch.delete
import os, requests

resp = requests.delete(
    "https://api.infrai.cc/v1/db/branch/delete/ID",
    headers={"Authorization": f"Bearer {os.environ['INFRAI_API_KEY']}"},
)
resp.raise_for_status()
print(resp.json())

javascript

// 1) Auth: every call is a raw HTTPS request carrying only your project key.
//    No SDK to install — just the built-in fetch().
const BASE = "https://api.infrai.cc";
const HEADERS = {
  "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
  "Content-Type": "application/json",
};


// 2) db.project.create
const resp = await fetch(
  "https://api.infrai.cc/v1/db/project/create",
  {
    method: "POST",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
      "Content-Type": "application/json",
    },
    body: JSON.stringify({"name": "..."}),
  },
);
console.log(await resp.json());

// 3) db.project.get
const resp = await fetch(
  "https://api.infrai.cc/v1/db/project/get/ID",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
console.log(await resp.json());

// 4) db.project.list
const resp = await fetch(
  "https://api.infrai.cc/v1/db/project/list",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
console.log(await resp.json());

// 5) db.project.delete
const resp = await fetch(
  "https://api.infrai.cc/v1/db/project/delete/ID",
  {
    method: "DELETE",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
console.log(await resp.json());

// 6) db.branch.create
const resp = await fetch(
  "https://api.infrai.cc/v1/db/branch/create",
  {
    method: "POST",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
      "Content-Type": "application/json",
    },
    body: JSON.stringify({"project_id": "...", "branch_name": "..."}),
  },
);
console.log(await resp.json());

// 7) db.branch.get
const resp = await fetch(
  "https://api.infrai.cc/v1/db/branch/get/ID",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
console.log(await resp.json());

// 8) db.branch.list
const resp = await fetch(
  "https://api.infrai.cc/v1/db/branch/list",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
console.log(await resp.json());

// 9) db.branch.delete
const resp = await fetch(
  "https://api.infrai.cc/v1/db/branch/delete/ID",
  {
    method: "DELETE",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
console.log(await resp.json());

typescript

// 1) Auth: every call is a raw HTTPS request carrying only your project key.
//    No SDK to install — just the built-in fetch(), typed.
const BASE = "https://api.infrai.cc";
const HEADERS: Record<string, string> = {
  "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
  "Content-Type": "application/json",
};


// 2) db.project.create
const resp = await fetch(
  "https://api.infrai.cc/v1/db/project/create",
  {
    method: "POST",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
      "Content-Type": "application/json",
    },
    body: JSON.stringify({"name": "..."}),
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

// 3) db.project.get
const resp = await fetch(
  "https://api.infrai.cc/v1/db/project/get/ID",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

// 4) db.project.list
const resp = await fetch(
  "https://api.infrai.cc/v1/db/project/list",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

// 5) db.project.delete
const resp = await fetch(
  "https://api.infrai.cc/v1/db/project/delete/ID",
  {
    method: "DELETE",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

// 6) db.branch.create
const resp = await fetch(
  "https://api.infrai.cc/v1/db/branch/create",
  {
    method: "POST",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
      "Content-Type": "application/json",
    },
    body: JSON.stringify({"project_id": "...", "branch_name": "..."}),
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

// 7) db.branch.get
const resp = await fetch(
  "https://api.infrai.cc/v1/db/branch/get/ID",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

// 8) db.branch.list
const resp = await fetch(
  "https://api.infrai.cc/v1/db/branch/list",
  {
    method: "GET",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);

// 9) db.branch.delete
const resp = await fetch(
  "https://api.infrai.cc/v1/db/branch/delete/ID",
  {
    method: "DELETE",
    headers: {
      "Authorization": `Bearer ${process.env.INFRAI_API_KEY}`,
    },
  },
);
if (!resp.ok) throw new Error(`infrai ${resp.status}`);
const data: unknown = await resp.json();
console.log(data);