Ninox MCP server

Connect Ninox to Claude, ChatGPT, Cursor, Claude Code, Codex, Gemini, GitHub Copilot and any other MCP client, for your whole team. Metorial adds security, governance, and tracing, and gives everyone one Magic MCP URL to connect.

What you can do with the Ninox MCP server

Ask your agent in plain language. Each of these maps to a real tool on the server.

  • Use the execute query tool in Ninox
  • Use the list databases tool in Ninox
  • Use the execute script tool in Ninox
  • Use the get table schema tool in Ninox
  • Use the list teams tool in Ninox
  • Use the update record tool in Ninox

Supported Tools

execute_query

Execute Query

Execute a read-only Ninox query expression against a database. Queries use Ninox's own query language to select and filter data. For example: `(select Contact).'First Name'` retrieves first names from a Contact table.

list_databases

List Databases

List all databases within a specified team. Returns database identifiers and names.

execute_script

Execute Script

Execute a Ninox script that can both read and write data. Can run complex queries, trigger global functions, compute formula field values, and modify records. More powerful than **Execute Query** but should be used carefully as it can alter data.

get_table_schema

Get Table Schema

Retrieve the schema of tables in a database, including field definitions (IDs, names, types, and choice options). Can return all tables or a specific table. Useful for discovering the data model before querying records.

list_teams

List Teams

List all teams (workspaces) accessible with the current authentication token. Teams are the top-level organizational unit in Ninox that contain databases.

update_record

Update Record

Update field values of an existing record. Only the specified fields will be modified; other fields remain unchanged.

delete_records

Delete Records

Delete one or more records from a table by their IDs. This action is irreversible.

create_records

Create Records

Create one or more new records in a table. Field values should use field names (not IDs) as keys. Use **Get Table Schema** to discover available fields.

list_files

List Files

List all files attached to a specific record. Returns file metadata including name, content type, size, and modification info.

get_database

Get Database

Retrieve full database details including its settings (name, icon, color) and complete schema configuration. Useful for understanding the overall database structure.

get_record

Get Record

Retrieve a single record by its ID from a specific table. Returns all field values and metadata for the record.

list_views

List Views

List views defined in a database or on a specific table. Views represent saved configurations for displaying and filtering data.

delete_file

Delete File

Delete a file attached to a record. This action is irreversible.

list_records

List Records

Retrieve records from a table with optional filtering, sorting, and pagination. Filters use field IDs (not field names) — use the **Get Table Schema** tool first to discover field IDs.

get_changes

Get Changes

Retrieve database or table changes after a sequence number, including updates, removed record IDs, and file or view changes. Save the returned seq value for the next request.

download_file

Download File

Prepare a file on a Ninox record for download. Use list_files to discover filenames.

upsert_records

Upsert Records

Insert or update records by numeric record ID. Fields use field IDs from get_table_schema. Useful for synchronizing records while preserving their IDs.

Connect Ninox to your AI client

Every client uses the same Magic MCP URL, and so does any other MCP client. Add it once and sign in with SSO.

  1. Enable Ninox in Metorial. In your Metorial portal, enable the Ninox MCP server and sign in with the account that owns the data. Access stays governed by your team policies.
  2. Add a custom connector. Open Customize, then Connectors. Select Add, then Custom, then Web.
  3. Paste your Metorial MCP URL. Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>) and continue.
  4. Sign in. Select Add and sign in to load Ninox tools.

Run Ninox through the Metorial gateway

One governed layer for every app your agents reach, not a separate connector per tool.

  • Give Ninox and every other app to your whole team through one MCP gateway, behind your SSO.
  • Scope which teams and agents can use Ninox tools with role-based access control, and trace every call.
  • Prefer to run it yourself? Metorial is open source and self-hostable.

More integrations teams use with Ninox

Notion

Create, read, update, and archive pages and databases in a Notion workspace. Manage blocks (paragraphs, lists, headings, embeds, etc.) within pages. Query databases with filters and sorts across rich property types including text, numbers, dates, selects, relations, and formulas. Search across pages and databases by title. Add and read comments on pages and blocks. Upload files to pages. Manage workspace users and retrieve user profiles.

Google Sheets

Create, read, and update spreadsheets and their cell data. Read and write values to individual cells, ranges, or multiple ranges using A1 notation or named ranges. Apply cell formatting including text styles, backgrounds, borders, number formats, and conditional formatting. Manage sheets (tabs) within a spreadsheet—add, delete, copy, rename, and reorder them. Create and manage embedded charts, pivot tables, filter views, data validation rules, protected ranges, named ranges, and merged cells. Perform batch operations to apply multiple updates atomically.

GitHub

Manage repositories, issues, and pull requests. Create and configure branches, star repositories, review code, and merge changes. Automate CI/CD workflows with GitHub Actions, manage workflow runs, secrets, and artifacts. Track issues with labels, milestones, and assignees. Search across code, repositories, issues, and users. Manage organizations, teams, and memberships. Create and manage projects, gists, packages, deployments, and environments. Access security alerts including code scanning, secret scanning, and Dependabot alerts. Read and write file contents in repositories. Manage webhooks, notifications, and codespaces.

Salesforce

Manage CRM data including Accounts, Contacts, Leads, Opportunities, Cases, and custom objects. Create, read, update, and delete records. Query data using SOQL and search across objects using SOSL. Perform bulk data operations for large-scale imports, exports, and migrations. Execute composite requests to batch multiple operations in a single API call. Access analytics, reports, and dashboards. Manage files and attachments associated with records. Interact with Chatter feeds, posts, and groups for social collaboration. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.

Sharepoint

Manage SharePoint sites, document libraries, lists, and files. Create, read, update, and delete lists and list items with custom columns. Resolve site users to numeric Person/Group LookupId values. Upload, download, move, copy, and version files in document libraries. Search across sites, files, folders, lists, and list items using Microsoft Search. Manage permissions at site, list, and item levels with granular access control. Define and manage content types and site columns. Retrieve site properties and search for sites across Microsoft 365.

Microsoft Outlook

Send, read, reply to, forward, and manage email messages in user mailboxes. Organize messages into folders, apply categories, flags, and importance levels. Manage file and item attachments. Create, update, delete, and respond to calendar events and meetings. Find available meeting times, manage attendees, handle recurrence, and work with shared or delegated calendars. Create, read, update, and delete contacts, organize them into contact folders, and manage contact photos. Manage tasks and task lists via Microsoft To Do, including due dates, reminders, recurrence, and checklist items. Support for Focused Inbox, @-mentions, mail tips, send-on-behalf, and send-as capabilities.

Technical notes for Ninox

Discover teams, databases, and table schemas in Ninox's low-code database platform. Create, read, filter, update, upsert, and delete records. Execute Ninox queries and writable scripts, inspect views, track database or table changes by sequence number, and list, download, or delete record files.

Frequently asked questions

Common questions about connecting Ninox to AI agents with Metorial.

  1. How many tools does the Ninox MCP server have?
    The Ninox MCP server exposes 17 tools, including Execute Query, List Databases, Execute Script. Each one is governed and traced through Metorial.
  2. Ninox exposes tools your agents call on demand; it does not publish event triggers yet. Everything still runs through one governed MCP URL.
  3. Any MCP client, including VS Code, Windsurf, Zed, OpenCode and Grok. Each one reaches the Ninox MCP server through the same Metorial URL.
  4. Use role-based access control to decide which teams, users, and agents can use Ninox and which of its tools they can call.
  5. Yes. Metorial is open source, so you can run the Ninox MCP server yourself or use the hosted gateway.

Connect Ninox to production AI agents

See how Metorial gives your team governed access to Ninox, with tracing and security controls built in.