Octonet Mcp

by apolocine

394 downloads

Not rated

GitHub

Database
AI

About

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

Details

Author: apolocine
Downloads: 394
Categories: Database, AI

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

Download and install Highlight from highlightai.com/download
Navigate to the plugins tab and select "Add Custom Plugin"
Configure the plugin with the settings below

Plugin Name Octonet Mcp

Command (node, npx, python, etc.)

Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
Enable "Start Automatically" if you want the plugin to start when Highlight launches

Setting up with Cursor

Open Cursor's settings
Navigate to the MCP section
Click "Add new Global MCP server"
Copy and paste the configuration below based on your operating system

JSON

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

JSON

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

JSON

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

Setting up with Claude Desktop

Open Claude Desktop's settings
Go to the Integrations tab
Click "Add MCP Server"
Use the configuration below based on your operating system

Note: Make sure Claude Desktop is running before attempting to connect.

JSON

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

JSON

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

JSON

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

Setting up with Windsurf

Open Windsurf's preferences
Go to the Integrations section
Click "Add MCP Integration"
Use the configuration below based on your operating system

JSON

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

JSON

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

JSON

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

Setting up with Cline

Open Cline's settings
Navigate to the Integrations section
Click "Add MCP Server"
Copy and paste the configuration below based on your operating system

Note: Make sure to restart Cline after adding the configuration.

JSON

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

JSON

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

JSON

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

Setting up with Goose

Open Goose's preferences
Go to the Integrations tab
Select "MCP Servers"
Click "Add New Server"
Use the configuration below based on your operating system

JSON

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

JSON

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

JSON

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

From the repository

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.

`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.

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

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

McpServers

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

OctoNet MCP

> 1 MCP server, 13 databases, zero config. ## Quick Start ``

bash
  npx octonet-mcp --dialect=postgres
  --uri=postgresql://user:pass@localhost:5432/mydb                   
   
  Claude Desktop Configuration                                       
                                          
  {
    "mcpServers": {
      "octonet": {
        "command": "npx",
        "args": ["octonet-mcp", "--dialect=sqlite", "--uri=:memory:"]
      }
    }                                                                
  }                                       

  Remote Server

  {                                                                  
    "mcpServers": {
      "octonet": {                                                   
        "url": "https://mcp.amia.fr/mcp"  
      }
    }
  }
                                                                     
  13 Databases
                                                                     
  PostgreSQL, MySQL, MariaDB, SQLite, Oracle, SQL Server, DB2, SAP   
  HANA, HSQLDB, Sybase, CockroachDB, Cloud Spanner, MongoDB.
                                                                     
  15 MCP Tools per Entity                 

  findAll, findById, create, update, delete, count, findOne, search, 
  upsert, deleteMany, updateMany, aggregate, addToSet, pull,
  increment.                                                         
                                          
  4 Prompts

  describe-schema, suggest-query, explain-data, list-entities.       
   
  Author                                                             
                                          
  Dr Hamid MADANI drmdh@msn.com

No reviews yet — be the first

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

About

Details

Jump to

Setting up with Highlight

From the repository

User_findAll

User_findById

User_create

User_update

User_delete

User_count

User_findOne

User_search

User_upsert

User_deleteMany

User_updateMany

User_aggregate

User_addToSet

User_pull

User_increment

Product_findAll

Product_findById

Product_create

Product_update

Product_delete

Product_count

Product_findOne

Product_search

Product_upsert

Product_deleteMany

Product_updateMany

Product_aggregate

Product_addToSet

Product_pull

Product_increment

Order_findAll

Order_findById

Order_create

Order_update

Order_delete

Order_count

Order_findOne

Order_search

Order_upsert

Order_deleteMany

Order_updateMany

Order_aggregate

Order_addToSet

Order_pull

Order_increment

Claude Desktop / Cursor

McpServers

OctoNet MCP

Install

More like this

Redis

Sqlite

PostgreSQL

Context 7

1Panel

🔎 GPT Researcher

`User_findAll`

`User_findById`

`User_create`

`User_update`

`User_delete`

`User_count`

`User_findOne`

`User_search`

`User_upsert`

`User_deleteMany`

`User_updateMany`

`User_aggregate`

`User_addToSet`

`User_pull`

`User_increment`

`Product_findAll`

`Product_findById`

`Product_create`

`Product_update`

`Product_delete`

`Product_count`

`Product_findOne`

`Product_search`

`Product_upsert`

`Product_deleteMany`

`Product_updateMany`

`Product_aggregate`

`Product_addToSet`

`Product_pull`

`Product_increment`

`Order_findAll`

`Order_findById`

`Order_create`

`Order_update`

`Order_delete`

`Order_count`

`Order_findOne`

`Order_search`

`Order_upsert`

`Order_deleteMany`

`Order_updateMany`

`Order_aggregate`

`Order_addToSet`

`Order_pull`

`Order_increment`