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.
Octonet MCP Server
@apolocine
关于 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 配置
使用下面的配置,将此服务器添加到你的 MCP 客户端。
{
"mcpServers": {
"octonet": {
"url": "https://octonet.amia.fr/mcp",
"headers": {
"X-API-Key": "YOUR_STRIPE_SECRET_KEY"
}
}
}
}Octonet MCP Server 工具
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.
概览
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
常见问题
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 drmdh@msn.com.
数据库 分类下的更多 MCP 服务器
PostgreSQL
modelcontextprotocolModel Context Protocol Servers
88.1K
Schemity
tbsonLocal database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.
MCP DB Wizard
srmadscienceOracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.
1
MongoDB MCP Server
mongodb-jsA Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.
1.1K
Sail MCP Server for Spark SQL
lakehqDrop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.
3.1K
评论