Anydb

anydb-mcp is a professional, zero-config Model Context Protocol (MCP) server that empowers AI agents to safely query SQL and NoSQL databases.

It acts as a universal bridge, allowing tools like Cursor, Claude, Gemini, and Zed to interact with your data effortlessly using a single unified interface.

✨ Features

• 🔌 Universal Support: Works with PostgreSQL, MySQL, SQLite, MongoDB, and Redis out of the box.
• 🚀 Zero Config: No configuration files required. Just run it via npx.
• ⚡ Stateless & Fast: Connections are created on-demand and closed immediately.
• 🛡️ Secure: Designed for read-only access (enforceable via DB users).
• 🧠 Smart Parsing: Automatically detects database types from standard connection URIs.

📦 Quick Start

You can run this server directly using npx without installing anything manually.

🤖 Choose Your Client

{
  "mcpServers": {
    "anydb": {
      "command": "npx",
      "args": ["-y", "anydb-mcp"]
    }
  }
}

{
  "context_servers": {
    "anydb": {
      "command": {
        "path": "npx",
        "args": ["-y", "anydb-mcp"]
      }
    }
  }
}

{
  "mcpServers": {
    "anydb": {
      "command": "npx",
      "args": ["-y", "anydb-mcp"]
    }
  }
}

"anydb": {
  "command": "npx",
  "args": ["-y", "anydb-mcp"]
}

🔗 Connection URIs

The AI agent will provide these URIs automatically, or you can provide them in the chat context.

🛠️ Tool Usage

The server exposes one powerful tool: db_query.

Arguments:

• uri (string, required): The connection string.
• query (string, required): The SQL query, MongoDB filter (JSON), or Redis command.
• collection (string, optional): Required only for MongoDB.

Examples:

SQL (Postgres/MySQL/SQLite):

SELECT id, email FROM users WHERE created_at > '2024-01-01' LIMIT 5;

MongoDB:

{ "status": "active", "age": { "$gt": 21 } }

Redis:

GET session:12345

🔒 Security Best Practices

1. Read-Only User: ALWAYS create a dedicated database user with SELECT-only permissions (or equivalent) for the AI.
   • Postgres: GRANT SELECT ON ALL TABLES IN SCHEMA public TO ai_user;
   • MySQL: GRANT SELECT ON mydb.* TO 'ai_user'@'%';
2. Network: Ensure the database host is accessible from the machine running the MCP server.
3. Data Privacy: Be cautious. The AI has access to whatever data the query returns.

👨‍💻 Contributing

We welcome contributions! Please see CONTRIBUTING.md for details.

1. Fork the repo.
2. npm install
3. npm test
4. Submit a Pull Request.

License

MIT © Alexeev Alexandr