Give your agent a real database: ingest JSON, get schema-validated Postgres tables, and query them with full SQL — JOINs, aggregations, millions of rows, millisecond reads. Set a trigger and your agent (or any webhook) hears about changes in seconds. Signup takes one tool call, no browser needed. How it works: - POST JSON to a source (your ingest endpoint) and Frostlake durably archives every event. - Define an entity — a typed schema with field names, types, and a primary key — and Frostlake materialises your events into a real Postgres table, validated on arrival. - Build a live table by writing any SQL SELECT over your entities: Frostlake keeps it incrementally up to date via CDC, no refresh job needed. - Attach a trigger to any entity or live table and a webhook fires within seconds of a row creation or field change.
How to connect
https://server.smithery.ai/frostlake/frostlake/mcpcurl -X POST https://server.smithery.ai/frostlake/frostlake/mcp \
-H 'Content-Type: application/json' \
-H 'Accept: application/json, text/event-stream' \
-d '{"jsonrpc":"2.0","id":1,"method":"initialize","params":{}}'