# Aiven MCP

> Aiven MCP is a freemium MCP server for databases. Manage Aiven PostgreSQL, Kafka and apps from an AI assistant, with read-only options. It can run locally on your machine or as a hosted remote server.

- **Kind:** MCP server
- **Pricing:** Freemium
- **Platforms:** API, CLI
- **Website:** https://aiven.io/mcp
- **Repository:** https://github.com/aiven-open/mcp-aiven
- **MCP Registry name:** io.aiven/mcp
- **Categories:** databases, cloud and infrastructure
- **Listing updated:** 2026-11-16

## About

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.

## Features

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

## Install

### Claude Code (Terminal)

```sh
claude mcp add mcp --env AIVEN_TOKEN='<AIVEN_TOKEN>' -- npx -y mcp-aiven
```

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-aiven"
      ],
      "env": {
        "AIVEN_TOKEN": "<AIVEN_TOKEN>"
      }
    }
  }
}
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-aiven"
      ],
      "env": {
        "AIVEN_TOKEN": "<AIVEN_TOKEN>"
      }
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-aiven"
      ],
      "env": {
        "AIVEN_TOKEN": "<AIVEN_TOKEN>"
      }
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-aiven"
      ],
      "env": {
        "AIVEN_TOKEN": "<AIVEN_TOKEN>"
      }
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-aiven"
      ],
      "env": {
        "AIVEN_TOKEN": "<AIVEN_TOKEN>"
      }
    }
  }
}
```

## Tools

- `aiven_kafka_topic_create`: Creates a Kafka topic.

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

- [Midplane](https://ai-powered.com/mcp/midplane): Midplane is an open-source MCP server for databases.
- [Agent Yurt](https://ai-powered.com/mcp/agent-yurt): Agent Yurt is a free MCP server for knowledge and memory.
- [Proofline](https://ai-powered.com/mcp/proofline): Proofline is a freemium MCP server for developer tools.
- [filex](https://ai-powered.com/mcp/filex): filex is an open-source MCP server for files and documents.
- [MagicWP MCP](https://ai-powered.com/mcp/magicwp-mcp): MagicWP MCP is an MCP server for cloud and infrastructure.
- [Kubana Cloud DNS Management](https://ai-powered.com/mcp/kubana-cloud-dns-management): Kubana Cloud DNS Management is a free MCP server for cloud and infrastructure.
- [AgentViva](https://ai-powered.com/mcp/agentviva): AgentViva is a free MCP server for developer tools.
- [Kubana Cloud Webmail](https://ai-powered.com/mcp/kubana-cloud-webmail): Kubana Cloud Webmail is a paid MCP server for communication.

---
Source: https://ai-powered.com/mcp/aiven-mcp
