所需权限：
dbconn:add请求体
string
required
显示名称
string
required
服务器主机名或地址
integer
default:"5432"
服务器端口，取值 1 到 65535
string
required
要读取的数据库名
string
required
用于认证的用户名
string
required
用于认证的密码。任何接口都不会返回它。
string
自由格式的描述
string
响应
object
curl -X POST 'https://app.memorylake.cn/openapi/memorylake/api/v3/db-connections' \
-H 'Authorization: Bearer sk_xxxxxx' \
-H 'Content-Type: application/json' \
-d '{
"name": "Sales warehouse",
"description": "Read-only replica of the sales database",
"host": "pg.internal.example.com",
"port": 5432,
"database": "sales",
"username": "analytics_ro",
"password": "your-database-password",
"custom_id": "sales-warehouse"
}'
{
"success": true,
"data": {
"id": "dbconn-7c1e9a4b2d6f4a8e9b3c5d7f1a2b4c6d",
"name": "Sales warehouse",
"description": "Read-only replica of the sales database",
"host": "pg.internal.example.com",
"port": 5432,
"username": "analytics_ro",
"database": "sales",
"custom_id": "sales-warehouse",
"datasource_count": 0,
"created_at": "2026-09-18T07:42:17.139Z",
"updated_at": "2026-09-18T07:42:17.139Z"
}
}
数据库连接
创建数据库连接
保存访问数据库的方式及其凭据
curl -X POST 'https://app.memorylake.cn/openapi/memorylake/api/v3/db-connections' \
-H 'Authorization: Bearer sk_xxxxxx' \
-H 'Content-Type: application/json' \
-d '{
"name": "Sales warehouse",
"description": "Read-only replica of the sales database",
"host": "pg.internal.example.com",
"port": 5432,
"database": "sales",
"username": "analytics_ro",
"password": "your-database-password",
"custom_id": "sales-warehouse"
}'
{
"success": true,
"data": {
"id": "dbconn-7c1e9a4b2d6f4a8e9b3c5d7f1a2b4c6d",
"name": "Sales warehouse",
"description": "Read-only replica of the sales database",
"host": "pg.internal.example.com",
"port": 5432,
"username": "analytics_ro",
"database": "sales",
"custom_id": "sales-warehouse",
"datasource_count": 0,
"created_at": "2026-09-18T07:42:17.139Z",
"updated_at": "2026-09-18T07:42:17.139Z"
}
}