Lobsterdb

MCP server for LobsterDB — managed PostgreSQL for AI agents. Provision databases, run SQL, evolve schemas with tracked migrations. No API keys, no human signup, no configuration.

Quick Start

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

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

On first use, an account is created automatically and your token is saved to ~/.lobsterdb/token.

Tools

Tool	Description
create_database	Provision a new Postgres database
list_databases	List all databases on the account
get_database	Get details and connection string for a database
delete_database	Permanently delete a database
query	Run parameterized SQL — SELECT, INSERT, UPDATE, DELETE. Supports multi-statement SQL (only the last statement's result is returned; intermediate results are discarded).
introspect_schema	Get table/column schema optimized for LLM context
migrate	Apply tracked, idempotent DDL migrations
list_migrations	Show schema change history
snapshot	Create a v2 DDL-aware point-in-time backup (Builder+)
get_account	View tier, limits, and usage

Environment Variables

Variable	Description
LOBSTERDB_API_KEY	API key (skips auto-signup and file persistence)
LOBSTERDB_API_URL	Custom API base URL (default: https://api.theclawdepot.com/db)

Links

• Website: theclawdepot.com/db
• SDK: @lobsterkit/db
• API docs: api.theclawdepot.com/db/docs

LobsterKit Ecosystem

This MCP server is part of the LobsterKit multi-product ecosystem. Accounts can be linked across LobsterVault, LobsterDB, and LobsterMail using a linkToken at signup, enabling a single Stripe customer and an automatic multi-product discount (see pricing).

License

MIT