Read-only by default
SQL runs inside a READ ONLY transaction. Tools that write appear only when you set read_only=false. The homepage example uses ?read_only=true.
Agents & MCP
Rivestack runs a hosted MCP server at mcp.rivestack.io/mcp. Add it to Claude Code, Cursor, or any MCP client that supports remote servers. It works with dedicated plans, Solo and up, not Hobby databases.
Read-only until you set read_only=false.
What it does
SQL runs inside a READ ONLY transaction. Tools that write appear only when you set read_only=false. The homepage example uses ?read_only=true.
The agent can create pgvector tables, build HNSW or DiskANN indexes, run similarity search, and read index stats.
create_database returns the price first. Nothing runs until the agent confirms.
Migrations and index builds land in the cluster activity log, next to backups and restores.
Sign in with OAuth, or send an rsk_ API key as a Bearer token. OAuth works without a key pasted into the page.
18 tools
Thirteen tools are on by default. Five write tools appear only when read_only=false.
| Tool | What it does |
|---|---|
| list_databases | List the databases on the account. |
| get_database | Read one database. |
| get_connection_string | Return the connection string for a database. |
| execute_sql | Run SQL. It runs inside a READ ONLY transaction by default. |
| explain | Show how Postgres plans a statement. |
| list_tables | List the tables in a database. |
| describe_table | Describe one table. |
| similarity_search | Search rows by vector similarity. |
| index_stats | Read statistics for an index. |
| list_backups | List backups for a database. |
| get_metrics | Read database metrics. |
| get_logs | Read database logs. |
| search_docs | Search the Rivestack docs. |
| Tool | What it does |
|---|---|
| create_database | Shows a price preview, then requires a confirmed call. |
| apply_migration | Apply a migration. |
| create_vector_table | Create a table for vectors. |
| create_index | Create an index. |
| restore_from_backup | Preview and confirm. The restore overwrites the database. |
Setup
The snippets below are the Claude Code and Cursor setup already published on the homepage. Both point at the read-only URL.
// Cursor · .cursor/mcp.json { "mcpServers": { "rivestack": { "url": "https://mcp.rivestack.io/mcp?read_only=true" } } }
# Claude Code claude mcp add --transport http rivestack \ "https://mcp.rivestack.io/mcp?read_only=true"
Agents & MCP
Solo is 7 days free for new customers, then $29/month. Card required.