Skip to content
MCP server

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-aiven

Add 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)Required
  • AIVEN_READ_ONLYSet to true to expose only read-only tools
  • AIVEN_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

  1. Midplane

    MCP server

    Postgres gateway for AI agents with table grants, column masking and approval for writes

    Runs locally
    • Open source
    • 5 GitHub stars
    • Databases
  2. Agent Yurt

    MCP server

    Back up agent memory, files and dashboards, then recover from a reviewed snapshot

    Not checked yet
    • Remote
    • Free
    • Knowledge and memory
  3. Proofline

    MCP server

    Production-aware review of changes against your AWS or Google Cloud setup, via MCP

    • Remote
    • Freemium
    • Developer tools
  4. filex

    MCP server

    Self-hosted file manager in one Go binary with a built-in MCP server for agents

    Not checked yet
    • Remote
    • Open source
    • Files and documents
  5. MagicWP MCP

    MCP server

    Run WordPress hosting from an assistant: backups, staging, updates, PHP and domains

    • Remote
    • Free trial
    • Cloud and infrastructure
  6. Create DNS zones, edit records and check nameserver delegation on Kubana Cloud

    Not checked yet
    • 5 tools
    • Remote
    • Free
    • Cloud and infrastructure