# Aiven MCP (MCP server)

> Aiven MCP is an MCP server that adds database tools to AI assistants such as Claude Desktop, Claude Code and Cursor. Provision PostgreSQL, manage Apache Kafka, and deploy apps with Aiven - all from your AI assistant. It has 28 GitHub stars, is released under the Apache-2.0 license and runs locally with npx -y mcp-aiven.

A Model Context Protocol (MCP) server for the Aiven cloud data platform. Manage PostgreSQL, Apache Kafka, applications, and other Aiven services directly from AI assistants like Claude, Cursor, and VS Code Copilot.

## Key facts

| Fact | Value |
|---|---|
| Repository | https://github.com/Aiven-Open/mcp-aiven |
| GitHub stars | 28 |
| License | Apache-2.0 |
| Language | TypeScript |
| Transport | stdio |
| Packages | npm: mcp-aiven |
| Remote URL | none |
| Needs API key | yes |
| Official | yes |
| Works with | Claude Desktop, Claude Code, Cursor, VS Code |
| Category | Databases |
| Latest release | v1.17.1 (Oct 6, 2026) |
| Last commit | Oct 5, 2026 |
| MCP registry name | io.aiven/mcp |

## Install

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "aiven-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-aiven"
      ],
      "env": {
        "AIVEN_TOKEN": "your-value",
        "AIVEN_ALLOW_SECRETS": "your-value"
      }
    }
  }
}
```

Settings > Developer > Edit Config. macOS: ~/Library/Application Support/Claude/, Windows: %APPDATA%\Claude\. Restart Claude Desktop afterwards.

### Claude Code

```sh
claude mcp add --env AIVEN_TOKEN=your-value --env AIVEN_ALLOW_SECRETS=your-value --transport stdio aiven-mcp -- npx -y mcp-aiven
```

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

```json
{
  "mcpServers": {
    "aiven-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-aiven"
      ],
      "env": {
        "AIVEN_TOKEN": "your-value",
        "AIVEN_ALLOW_SECRETS": "your-value"
      }
    }
  }
}
```

Project file; use ~/.cursor/mcp.json to enable it in every project.

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

```json
{
  "inputs": [
    {
      "type": "promptString",
      "id": "aiven_token",
      "description": "AIVEN_TOKEN",
      "password": true
    },
    {
      "type": "promptString",
      "id": "aiven_allow_secrets",
      "description": "AIVEN_ALLOW_SECRETS",
      "password": true
    }
  ],
  "servers": {
    "aiven-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-aiven"
      ],
      "env": {
        "AIVEN_TOKEN": "${input:aiven_token}",
        "AIVEN_ALLOW_SECRETS": "${input:aiven_allow_secrets}"
      }
    }
  }
}
```

Config formats checked against the official docs on 2026-10-07.

## Environment variables

- `AIVEN_TOKEN` (secret) (required): Aiven API token (create one at https://console.aiven.io/profile/tokens)
- `AIVEN_READ_ONLY`: Set to true to expose only read-only tools
- `AIVEN_SERVICES_SCOPE`: Comma-separated scopes to expose (e.g. pg, kafka, pg,kafka, or all). Valid: all, core, pg, kafka, application, integrations.
- `AIVEN_ALLOW_SECRETS` (secret): Set to true to let the connection-info tool return live credentials instead of [REDACTED].

## Tools

- `aiven_project_list`: List projects
- `aiven_project_get`: Get project details
- `aiven_list_project_clouds`: List cloud platforms for a project
- `aiven_project_vpc_list`: List VPCs for a project
- `aiven_service_list`: List services
- `aiven_service_type_plans`: List plans with cloud availability
- `aiven_service_type_get`: Get default and available engine versions for a service type
- `aiven_service_plan_pricing`: Get pricing for a plan in a specific cloud
- `aiven_service_create`: Create a service
- `aiven_service_get`: Get service information
- `aiven_service_update`: Update a service (plan, config, power state)
- `aiven_service_metrics_fetch`: Fetch metrics for managed data services
- `aiven_service_application_metrics_get`: Fetch metrics for application services
- `aiven_project_get_service_logs`: Get service log entries
- `aiven_service_query_activity`: Fetch current queries for a service
- `aiven_project_get_event_logs`: Get project event log entries
- `aiven_kafka_topic_list`: List Kafka topics
- `aiven_kafka_topic_create`: Create a Kafka topic
- `aiven_kafka_topic_get`: Get Kafka topic info
- `aiven_kafka_topic_update`: Update a Kafka topic
- `aiven_kafka_topic_delete`: Delete a Kafka topic
- `aiven_kafka_topic_message_list`: Read messages from a Kafka topic
- `aiven_kafka_topic_message_produce`: Produce messages into a Kafka topic
- `aiven_kafka_connect_available_connectors`: List available connector types
- `aiven_kafka_connect_list`: List running connectors
- `aiven_kafka_connect_create_connector`: Create a connector
- `aiven_kafka_connect_edit_connector`: Edit a connector
- `aiven_kafka_connect_get_connector_status`: Get connector status
- `aiven_kafka_connect_pause_connector`: Pause a connector
- `aiven_kafka_connect_resume_connector`: Resume a connector
- `aiven_kafka_connect_restart_connector`: Restart a connector
- `aiven_kafka_connect_delete_connector`: Delete a connector
- `aiven_kafka_schema_registry_subjects`: List Schema Registry subjects
- `aiven_kafka_schema_registry_subject_version_get`: Get Schema Registry subject version
- `aiven_pg_service_available_extensions`: List available extensions
- `aiven_pg_service_query_statistics`: Fetch query statistics
- `aiven_pg_bouncer_create`: Create a PgBouncer connection pool
- `aiven_pg_bouncer_update`: Update a PgBouncer connection pool
- `aiven_pg_bouncer_delete`: Delete a PgBouncer connection pool
- `aiven_pg_read`: Run a read-only SQL query

## Similar MCP servers

- [Dbx](https://appsgit.com/mcp-servers/dbx): Query databases from AI agents using connections configured in DBX. (24,945 stars, Apache-2.0)
- [Butterbase AI MCP Server](https://appsgit.com/mcp-servers/butterbase-ai-mcp-server): Butterbase MCP server — manage your backend: schemas, auth, functions, storage, RAG, deploys. (3,686 stars, Apache-2.0, needs API key)
- [DBHub](https://appsgit.com/mcp-servers/dbhub): Token-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite. (3,610 stars, MIT, needs API key)
- [LINQ to DB](https://appsgit.com/mcp-servers/linq-to-db): Inspect database schemas and execute SQL queries across multiple database providers with LINQ to DB. (3,332 stars, MIT)
- [Mindwtr](https://appsgit.com/mcp-servers/mindwtr): Task automation via SQLite, desktop Local API, or Mindwtr Cloud; read-only by default. (2,211 stars, AGPL-3.0, needs API key)
- [MCP Memory Service](https://appsgit.com/mcp-servers/mcp-memory-service): Open-source persistent memory for AI agent pipelines (LangGraph, CrewAI, AutoGen) and Claude. (1,988 stars, Apache-2.0)

---

Canonical page: https://appsgit.com/mcp-servers/aiven-mcp
Source: appsgit (https://appsgit.com), the app store for github. Data from the GitHub API, refreshed nightly.
Machine access: JSON API https://appsgit.com/api/v1/apps (OpenAPI: https://appsgit.com/openapi.json), MCP server https://mcp.appsgit.com/mcp, full index https://appsgit.com/llms-full.txt.
