MCP.so
Sign In

Octonet MCP Server

@apolocine

Basic information

Category

Databases

Transports

stdio

Auth

oauth

Author

apolocine

Submitted by

MADANI

About Octonet MCP Server

1 MCP server, 13 databases, zero config. Connect AI agents to PostgreSQL, MySQL, MongoDB, SQLite, Oracle, SQL Server, DB2, SAP HANA, MariaDB, CockroachDB, Cloud Spanner, HSQLDB, Sybase. 15 tools per entity + 4 AI prompts. Auth + RBAC included. 11 transports: REST, GraphQL

Octonet MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "octonet": {
      "url": "https://octonet.amia.fr/mcp",
      "headers": {
        "X-API-Key": "YOUR_STRIPE_SECRET_KEY"
      }
    }
  }
}

Octonet MCP Server tools

45

Find all User entities. Optionally filter, sort, limit.

Find a User entity by its ID.

Create a new User entity.

Update a User entity by ID.

Delete a User entity by ID.

Count User entities. Optionally filter.

Find a single User entity matching a filter.

Search User entities by text query.

Insert or update a User entity. Finds by filter, creates if not found.

Delete multiple User entities matching a filter.

Update multiple User entities matching a filter.

Run an aggregation pipeline on User entities.

Add a value to an array field of a User entity (no duplicates).

Remove a value from an array field of a User entity.

Increment a numeric field of a User entity.

Find all Product entities. Optionally filter, sort, limit.

Find a Product entity by its ID.

Create a new Product entity.

Update a Product entity by ID.

Delete a Product entity by ID.

Count Product entities. Optionally filter.

Find a single Product entity matching a filter.

Search Product entities by text query.

Insert or update a Product entity. Finds by filter, creates if not found.

Delete multiple Product entities matching a filter.

Update multiple Product entities matching a filter.

Run an aggregation pipeline on Product entities.

Add a value to an array field of a Product entity (no duplicates).

Remove a value from an array field of a Product entity.

Increment a numeric field of a Product entity.

Find all Order entities. Optionally filter, sort, limit.

Find a Order entity by its ID.

Create a new Order entity.

Update a Order entity by ID.

Delete a Order entity by ID.

Count Order entities. Optionally filter.

Find a single Order entity matching a filter.

Search Order entities by text query.

Insert or update a Order entity. Finds by filter, creates if not found.

Delete multiple Order entities matching a filter.

Update multiple Order entities matching a filter.

Run an aggregation pipeline on Order entities.

Add a value to an array field of a Order entity (no duplicates).

Remove a value from an array field of a Order entity.

Increment a numeric field of a Order entity.

Overview

What is Octonet Mcp?

Octonet Mcp is an MCP server that provides a unified interface to interact with 13 different databases, enabling zero-configuration database management through the Model Context Protocol. It offers 15 tools per entity and 4 built-in prompts for schema description, query suggestions, data explanation, and entity listing.

How to use Octonet Mcp?

Install via npx octonet-mcp with the required --dialect and --uri arguments to specify the database type and connection string. For Claude Desktop, configure an MCP server entry using the command and args, or use the remote server URL https://mcp.amia.fr/mcp.

Key features of Octonet Mcp

  • Supports 13 different database systems
  • Provides 15 MCP tools per entity (CRUD and more)
  • Includes 4 prompts for schema and data exploration
  • Zero-configuration setup for quick connections
  • Can run as a local or remote MCP server
  • Compatible with Claude Desktop integration

Use cases of Octonet Mcp

  • Interact with multiple database types from a single MCP endpoint
  • Automate common database operations like create, read, update, delete
  • Use prompts to describe schemas, suggest queries, explain data, or list entities
  • Simplify database management inside AI assistants such as Claude

Frequently asked questions

1

What databases does Octonet Mcp support?

It supports PostgreSQL, MySQL, MariaDB, SQLite, Oracle, SQL Server, DB2, SAP HANA, HSQLDB, Sybase, CockroachDB, Cloud Spanner, and MongoDB.

2

How do I install Octonet Mcp?

Run `npx octonet-mcp` with the `--dialect` (e.g., postgres, sqlite) and `--uri` (connection string) arguments. No additional installation steps are required.

3

Can I run Octonet Mcp as a remote server?

Yes, a remote server is available at `https://mcp.amia.fr/mcp`. You can use this URL in your MCP client configuration instead of running a local instance.

4

What tools and prompts does Octonet Mcp provide?

It offers 15 tools per entity: findAll, findById, create, update, delete, count, findOne, search, upsert, deleteMany, updateMany, aggregate, addToSet, pull, increment. The 4 prompts are: describe-schema, suggest-query, explain-data, and list-entities.

5

Who is the author of Octonet Mcp?

The author is Dr Hamid MADANI, contactable at drmdh@msn.com.

Comments

More Databases MCP servers