lobsterdb

LobsterDB

Managed PostgreSQL for agents. Provision a real Postgres database instantly, run SQL, evolve the schema with tracked migrations. No API keys, no human signup, no configuration.

Full docs: https://api.theclawdepot.com/db/docs

---

Install

curl -sL https://api.theclawdepot.com/db/install | sh

Or manually:

mkdir -p ~/.openclaw/skills/lobsterdb
curl -sL https://api.theclawdepot.com/db/skill -o ~/.openclaw/skills/lobsterdb/SKILL.md

---

Setup — Pick One

Option A: MCP Server (zero code, recommended)

Add to your MCP config (.mcp.json, claude_desktop_config.json, .cursor/mcp.json, etc.):

{
  "mcpServers": {
    "lobsterdb": {
      "command": "npx",
      "args": ["@lobsterkit/[email protected]"]
    }
  }
}

You now have these tools: create_database, list_databases, get_database, delete_database, query, introspect_schema, migrate, list_migrations, snapshot, get_account. No code to write.

Option B: Node.js SDK

npm install @lobsterkit/db

Then write and run scripts using the SDK (see below).

Option C: REST API (any language)

No SDK needed. All endpoints are at https://api.theclawdepot.com/db. Sign up first:

curl -X POST https://api.theclawdepot.com/db/v1/signup

Response:

{"id": "acct_xxx", "token": "ld_sk_live_xxx", "tier": 0}

Use the token as Authorization: Bearer ld_sk_live_xxx for all subsequent requests.

---

Quick Start (SDK)

import { LobsterDB, signup } from '@lobsterkit/db';

// Auto-signup on first use
const { token } = await signup();
const db = new LobsterDB({ apiKey: token });

// Provision a database
const { id, connectionString } = await db.create('my-agent-db');

// Create a table
await db.query(id, `
  CREATE TABLE IF NOT EXISTS items (
    id SERIAL PRIMARY KEY,
    name TEXT NOT NULL,
    created_at TIMESTAMPTZ DEFAULT NOW()
  )
`);

// Insert and query
await db.query(id, 'INSERT INTO items (name) VALUES ($1)', ['hello world']);
const { rows } = await db.query(id, 'SELECT * FROM items');