# OctoNet MCP

1 MCP server, 13 databases, zero config. 15 tools per entity + 4 AI prompts. Supports PostgreSQL, MySQL, MongoDB, SQLite, Oracle, SQL Server, DB2, SAP HANA, CockroachDB, Cloud Spanner, MariaDB, HSQLD…

## Quick Start

```bash
# Connect this server (installs CLI if needed)
npx -y smithery mcp add mostajs/octonet-mcp

# Browse available tools
npx -y smithery tool list mostajs/octonet-mcp

# Get full schema for a tool
npx -y smithery tool get mostajs/octonet-mcp User_findAll

# Call a tool
npx -y smithery tool call mostajs/octonet-mcp User_findAll '{}'
```

## Direct MCP Connection

Endpoint: `https://octonet-mcp--mostajs.run.tools`

## Tools (45)

- `User_findAll` — Find all User entities. Optionally filter, sort, limit.
- `User_findById` — Find a User entity by its ID.
- `User_create` — Create a new User entity.
- `User_update` — Update a User entity by ID.
- `User_delete` — Delete a User entity by ID.
- `User_count` — Count User entities. Optionally filter.
- `User_findOne` — Find a single User entity matching a filter.
- `User_search` — Search User entities by text query.
- `User_upsert` — Insert or update a User entity. Finds by filter, creates if not found.
- `User_deleteMany` — Delete multiple User entities matching a filter.
- `User_updateMany` — Update multiple User entities matching a filter.
- `User_aggregate` — Run an aggregation pipeline on User entities.
- `User_addToSet` — Add a value to an array field of a User entity (no duplicates).
- `User_pull` — Remove a value from an array field of a User entity.
- `User_increment` — Increment a numeric field of a User entity.
- `Product_findAll` — Find all Product entities. Optionally filter, sort, limit.
- `Product_findById` — Find a Product entity by its ID.
- `Product_create` — Create a new Product entity.
- `Product_update` — Update a Product entity by ID.
- `Product_delete` — Delete a Product entity by ID.
- `Product_count` — Count Product entities. Optionally filter.
- `Product_findOne` — Find a single Product entity matching a filter.
- `Product_search` — Search Product entities by text query.
- `Product_upsert` — Insert or update a Product entity. Finds by filter, creates if not found.
- `Product_deleteMany` — Delete multiple Product entities matching a filter.
- `Product_updateMany` — Update multiple Product entities matching a filter.
- `Product_aggregate` — Run an aggregation pipeline on Product entities.
- `Product_addToSet` — Add a value to an array field of a Product entity (no duplicates).
- `Product_pull` — Remove a value from an array field of a Product entity.
- `Product_increment` — Increment a numeric field of a Product entity.
- `Order_findAll` — Find all Order entities. Optionally filter, sort, limit.
- `Order_findById` — Find a Order entity by its ID.
- `Order_create` — Create a new Order entity.
- `Order_update` — Update a Order entity by ID.
- `Order_delete` — Delete a Order entity by ID.
- `Order_count` — Count Order entities. Optionally filter.
- `Order_findOne` — Find a single Order entity matching a filter.
- `Order_search` — Search Order entities by text query.
- `Order_upsert` — Insert or update a Order entity. Finds by filter, creates if not found.
- `Order_deleteMany` — Delete multiple Order entities matching a filter.
- `Order_updateMany` — Update multiple Order entities matching a filter.
- `Order_aggregate` — Run an aggregation pipeline on Order entities.
- `Order_addToSet` — Add a value to an array field of a Order entity (no duplicates).
- `Order_pull` — Remove a value from an array field of a Order entity.
- `Order_increment` — Increment a numeric field of a Order entity.

```bash
# Get full input/output schema for a tool
npx -y smithery tool get mostajs/octonet-mcp <tool-name>
```

## Resources

- `entity://User/schema` — Schema definition for User entity
- `entity://Product/schema` — Schema definition for Product entity
- `entity://Order/schema` — Schema definition for Order entity

## Prompts (4)

- `describe-schema` — Describe all available entities, their fields, and relations
- `suggest-query` (entity, goal) — Help build a query for a specific entity
- `explain-data` (entity, data) — Explain the data returned by a query in human-readable format
- `list-entities` — List all available entities with their field count