KosmoKrator

productivity

NocoDB MCP Integration for OpenAI Agents SDK

Connect NocoDB to OpenAI Agents SDK through the local KosmoKrator MCP gateway with scoped tools, credentials, and write policy.

15 functions 8 read 7 write API token auth
Submit NocoDB feedback View package source

Connect NocoDB to OpenAI Agents SDK

Attach KosmoKrator integration tools to OpenAI Agents SDK workflows through a local MCP gateway.

Start the KosmoKrator MCP gateway locally and point the OpenAI Agents SDK MCP tool at that process or wrapper. The gateway is local, scoped to this integration, and starts with --write=deny so OpenAI Agents can inspect read-capable tools without receiving write access by default.

NocoDB MCP Config for OpenAI Agents SDK

Use headless JSON commands for CI-style execution and MCP for agent tool discovery.

{
  "mcpServers": {
    "kosmokrator-nocodb": {
      "type": "stdio",
      "command": "kosmo",
      "args": [
        "mcp:serve",
        "--integration=nocodb",
        "--write=deny"
      ]
    }
  }
}

Run the Gateway Manually

kosmokrator mcp:serve --integration=nocodb --write=deny

Why Use KosmoKrator Here

Scoped tools

Expose only NocoDB instead of a broad multi-service tool list.

Local credentials

Reuse credentials already configured for the KosmoKrator CLI and Lua runtime.

Write policy

Start read-only, then opt into ask or allow for trusted workspaces.

NocoDB Tools Visible to OpenAI Agents

OpenAI Agents sees stable MCP tool names generated from the NocoDB integration catalog.

MCP toolSource functionTypeDescription
integration__nocodb__nocodb_list_records nocodb.nocodb_list_records Read List records from a NocoDB table with optional filtering, sorting, and pagination.
integration__nocodb__nocodb_get_record nocodb.nocodb_get_record Read Get a single NocoDB record by ID.
integration__nocodb__nocodb_create_record nocodb.nocodb_create_record Write Create a new record in a NocoDB table.
integration__nocodb__nocodb_update_record nocodb.nocodb_update_record Write Update an existing NocoDB record.
integration__nocodb__nocodb_delete_record nocodb.nocodb_delete_record Write Delete a record from a NocoDB table.
integration__nocodb__nocodb_batch_create nocodb.nocodb_batch_create Write Create multiple records in a single NocoDB API request.
integration__nocodb__nocodb_batch_update nocodb.nocodb_batch_update Write Update multiple records in a single NocoDB API request.
integration__nocodb__nocodb_batch_delete nocodb.nocodb_batch_delete Write Delete multiple records in a single NocoDB API request.
integration__nocodb__nocodb_list_bases nocodb.nocodb_list_bases Read List all NocoDB bases the token has access to.
integration__nocodb__nocodb_get_base nocodb.nocodb_get_base Read Get details of a single NocoDB base.
integration__nocodb__nocodb_list_tables nocodb.nocodb_list_tables Read List all tables in a NocoDB base.
integration__nocodb__nocodb_get_table nocodb.nocodb_get_table Read Get details of a single NocoDB table.
integration__nocodb__nocodb_create_table nocodb.nocodb_create_table Write Create a new table in a NocoDB base.
integration__nocodb__nocodb_list_views nocodb.nocodb_list_views Read List views for a NocoDB table.
integration__nocodb__nocodb_count_records nocodb.nocodb_count_records Read Count records in a NocoDB table with optional filtering.

Related NocoDB Pages

NocoDB CLIUse direct JSON commands instead of MCP discovery. NocoDB MCPFull gateway reference and MCP tool names. KosmoKrator for OpenAI AgentsClient-level gateway setup.