跳到正文

托管数据库

托管 Postgres:预置项目、写时复制分支与时间点快照,覆盖 Neon / Supabase / PlanetScale。

概览

基础路径: https://api.infrai.cc/v1/db
鉴权头: 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"

方法

db.project.create

POST /v1/db/project/create

在所选 vendor(Neon/Supabase/PlanetScale)上预置一个托管 Postgres 项目。

参数

名称类型必填说明
namestring
必填
数据库项目名称。
vendorstring可选显式 vendor 锁定;mode=byok 时必填。
regionstring可选预置所在区域。
planstring可选预置套餐 / 规格。
mode"managed" | "byok"可选预置模式——managed 或 byok。
postgres_versionstring可选Postgres 主版本。
idempotency_keystring可选客户端提供的幂等键。

返回

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

示例

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

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": "..."}'

db.project.get

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

按 id 获取托管数据库项目,含连接 URI。

参数

名称类型必填说明
idstring
必填
项目 id。

返回

Project

示例

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

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"

db.project.list

GET /v1/db/project/list

列出账户下的托管数据库项目。

参数

名称类型必填说明
cursorstring可选不透明分页游标。
limitnumber可选返回条目的最大数量。

返回

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

示例

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

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"

db.project.delete

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

删除托管数据库项目及其全部分支 / 快照。

参数

名称类型必填说明
idstring
必填
项目 id。

返回

{ ok: boolean }

示例

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

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"

db.branch.create

POST /v1/db/branch/create

为项目创建写时复制分支,用于预览或测试。

参数

名称类型必填说明
project_idstring
必填
项目 id。
branch_namestring
必填
新分支名称。
from_branchstring可选用于克隆的源分支。
idempotency_keystring可选客户端提供的幂等键。

返回

Branch { id, branch_name, project_id, connection_uri }

示例

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

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": "..."}'

db.branch.get

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

按 id 获取数据库分支,含连接 URI。

参数

名称类型必填说明
idstring
必填
分支 id。

返回

Branch

示例

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

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"

db.branch.list

GET /v1/db/branch/list

列出托管数据库项目的分支。

参数

名称类型必填说明
project_idstring可选项目 id。
cursorstring可选不透明分页游标。
limitnumber可选返回条目的最大数量。

返回

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

示例

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

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"

db.branch.delete

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

删除数据库分支。

参数

名称类型必填说明
idstring
必填
分支 id。

返回

{ ok: boolean }

示例

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

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"

db.snapshot.create

POST /v1/db/snapshot/create

为托管数据库项目创建一次时间点快照。

参数

名称类型必填说明
project_idstring
必填
项目 id。
labelstring可选可读的快照标签。
idempotency_keystring可选客户端提供的幂等键。

返回

Snapshot { id, project_id, label?, created_at }

示例

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

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": "..."}'

db.snapshot.get

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

按 id 获取数据库快照。

参数

名称类型必填说明
idstring
必填
快照 id。

返回

Snapshot

示例

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

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"

db.snapshot.list

GET /v1/db/snapshot/list

列出托管数据库项目的快照。

参数

名称类型必填说明
project_idstring可选项目 id。
cursorstring可选不透明分页游标。
limitnumber可选返回条目的最大数量。

返回

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

示例

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

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"

db.snapshot.restore

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

将快照恢复为一个新的托管数据库项目。

参数

名称类型必填说明
snapshot_idstring
必填
快照 id。
new_namestring可选恢复后项目的名称(默认为源项目名加 -restored 后缀)。
idempotency_keystring可选客户端提供的幂等键。

返回

Project { id, name, connection_uri }

示例

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

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": "..."}'
高级:指定 vendor

默认情况下 infrai 会把每次调用智能路由到最佳可用供应商——无需自己挑选 vendor。作为高级逃生口,本能力支持可选的 vendor 入参以锁定某个供应商。本能力当前所有可用 vendor 可通过该能力 id 对应的 discovery 端点实时获取——参见 discovery API

GET /v1/discovery/{capability}

db.project.create

全部能力

本模块全部已路由能力——完整的对外 REST 契约。上方方法是带讲解的入门示例,此表是完整参考。

能力端点说明
db.branch.createPOST /v1/db/branch/createdb branch create — managed database (Neon/Supabase/PlanetScale).
db.branch.deleteDELETE /v1/db/branch/delete/{id}db branch delete — managed database (Neon/Supabase/PlanetScale).
db.branch.getGET /v1/db/branch/get/{id}db branch get — managed database (Neon/Supabase/PlanetScale).
db.branch.listGET /v1/db/branch/listdb branch list — managed database (Neon/Supabase/PlanetScale).
db.project.createPOST /v1/db/project/createdb project create — managed database (Neon/Supabase/PlanetScale).
db.project.deleteDELETE /v1/db/project/delete/{id}db project delete — managed database (Neon/Supabase/PlanetScale).
db.project.getGET /v1/db/project/get/{id}db project get — managed database (Neon/Supabase/PlanetScale).
db.project.listGET /v1/db/project/listdb project list — managed database (Neon/Supabase/PlanetScale).
db.snapshot.createPOST /v1/db/snapshot/createdb snapshot create — managed database (Neon/Supabase/PlanetScale).
db.snapshot.getGET /v1/db/snapshot/get/{id}db snapshot get — managed database (Neon/Supabase/PlanetScale).
db.snapshot.listGET /v1/db/snapshot/listdb snapshot list — managed database (Neon/Supabase/PlanetScale).
db.snapshot.restorePOST /v1/db/snapshot/restore/{id}db snapshot restore — managed database (Neon/Supabase/PlanetScale).

完整示例

本模块的生产级端到端范例:先一次性配置,再运行业务流程,尽量覆盖本模块的多数 API。

单文件可运行 Python 程序(仅标准库、无 SDK):拷贝后填入 INFRAI_API_KEY 运行,即可按真实业务流逐步体验本模块核心 API——每一步都真实调用并计费,后续步骤复用前一步返回的真实字段。12 行 helper 就是全部集成代码。

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"))