Octonet Mcp
@apolocine
About Octonet Mcp
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
Basic information
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": "sk_live_cc3460b5b6502008d6fe3b09249dcdc0eb4b1daa24701083190f8dcf83336799"
}
}
}
}Tools
45Find 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
FAQ from Octonet Mcp
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.
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.
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.
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.
Who is the author of Octonet Mcp?
The author is Dr Hamid MADANI, contactable at [email protected].
More Databases MCP servers
Elasticsearch MCP Server
elastic
mcp_mysql_server
xwb602625136Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展
Dbhub
bytebaseZero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.
Chroma MCP Server
chroma-coreA Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma
Sail MCP Server for Spark SQL
lakehqDrop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.
Comments