Aiven MCP
Manage Aiven PostgreSQL, Kafka and apps from an AI assistant, with read-only options
- Pricing
- Freemium
- Platforms
- API, CLI
- Runs
- Locally or Remotely
- Version
- 1.20.0
- Listing updated
- 1 day ago
About Aiven MCP
Aiven MCP is a freemium MCP server for databases. It can run locally on your machine or as a hosted remote server.
Aiven's server runs hosted or locally via npm (mcp-aiven) and acts as your Aiven user, so it can do only what your permissions allow. The README warns it can create, modify and delete services and data.
The remote URL accepts query switches: read_only=true removes writes, services_scope narrows tools to pg, kafka, application, integrations or opensearch (core discovery is always on), and write_allowlist re-enables chosen writes. The local package adds AIVEN_ALLOW_SECRETS to return live credentials instead of redacted ones.
Sample uses are diagnosing slow queries with pg_stat_statements and EXPLAIN, enabling pgvector, producing and consuming Kafka messages, checking migrated row counts and auditing roles.
Install
Run in a terminal
claude mcp add mcp --env AIVEN_TOKEN='<AIVEN_TOKEN>' -- npx -y mcp-aivenAdd to claude_desktop_config.json
{
"mcpServers": {
"mcp": {
"command": "npx",
"args": [
"-y",
"mcp-aiven"
],
"env": {
"AIVEN_TOKEN": "<AIVEN_TOKEN>"
}
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"mcp": {
"command": "npx",
"args": [
"-y",
"mcp-aiven"
],
"env": {
"AIVEN_TOKEN": "<AIVEN_TOKEN>"
}
}
}
}Add to .vscode/mcp.json
{
"servers": {
"mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"mcp-aiven"
],
"env": {
"AIVEN_TOKEN": "<AIVEN_TOKEN>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"mcp": {
"command": "npx",
"args": [
"-y",
"mcp-aiven"
],
"env": {
"AIVEN_TOKEN": "<AIVEN_TOKEN>"
}
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"mcp": {
"command": "npx",
"args": [
"-y",
"mcp-aiven"
],
"env": {
"AIVEN_TOKEN": "<AIVEN_TOKEN>"
}
}
}
}Configuration
AIVEN_TOKENAiven API token (create one at https://console.aiven.io/profile/tokens)RequiredAIVEN_READ_ONLYSet to true to expose only read-only toolsAIVEN_SERVICES_SCOPEComma-separated scopes to expose (e.g. pg, kafka, pg,kafka, or all). Valid: all, core, pg, kafka, application, integrations, opensearch.AIVEN_ALLOW_SECRETSSet to true to let the connection-info tool return live credentials instead of [REDACTED].
Tools this server provides (1)
Taken from the project documentation; the running server may differ.
- aiven_kafka_topic_create
- Creates a Kafka topic.
What it does
- PostgreSQL
- Run SQL, manage schemas, indexes and extensions.
- Kafka
- Create topics and produce or consume messages.
- Read-only mode
- Exclude all writes.
- Scoped tools
- Limit exposed tools.
- Redacted secrets
- Credentials hidden unless allowed.
Good for
- Diagnose slow queries
- Create a Kafka topic
- Enable pgvector
- Verify a migration
Pricing
Freemium
Server free with an Aiven account; managed services priced separately, free PostgreSQL plan available
Prices change. Check aiven.io before you buy.
Aiven MCP FAQ
Cost?
Free with an Aiven account; services have their own pricing.
Can it delete things?
Yes, within your permissions; use read-only to prevent writes.
Hosted?
Yes at mcp.aiven.live.
Auth?
OAuth hosted or AIVEN_TOKEN locally.
Is Aiven MCP free?
Aiven MCP has a free plan, with paid plans for more usage or features.
How do I add Aiven MCP to Claude Code?
Run this command in your terminal: claude mcp add mcp --env AIVEN_TOKEN='<AIVEN_TOKEN>' -- npx -y mcp-aiven
What are the best alternatives to Aiven MCP?
The closest alternatives to Aiven MCP are Midplane, Agent Yurt, Proofline, filex and MagicWP MCP.
Alternatives to Aiven MCP

Midplane
MCP serverPostgres gateway for AI agents with table grants, column masking and approval for writes
Runs locally- Open source
- 5 GitHub stars
- Databases

Agent Yurt
MCP serverBack up agent memory, files and dashboards, then recover from a reviewed snapshot
Not checked yet- Remote
- Free
- Knowledge and memory

Proofline
MCP serverProduction-aware review of changes against your AWS or Google Cloud setup, via MCP
- Remote
- Freemium
- Developer tools

filex
MCP serverSelf-hosted file manager in one Go binary with a built-in MCP server for agents
Not checked yet- Remote
- Open source
- Files and documents

MagicWP MCP
MCP serverRun WordPress hosting from an assistant: backups, staging, updates, PHP and domains
- Remote
- Free trial
- Cloud and infrastructure

Kubana Cloud DNS Management
MCP serverCreate DNS zones, edit records and check nameserver delegation on Kubana Cloud
Not checked yet- 5 tools
- Remote
- Free
- Cloud and infrastructure