# Ninox MCP for AI Agents AI Agent Connect

> Ninox MCP for AI Agents. Connect your Ninox account to your AI client to manage business databases, automate record updates, and run custom scripts using natural language. Stop switching between your database and chat. This integration gives you a direct way to handle your low-code database orchestration and business automation through conversation, turning your database into a conversational workspace.

## Overview
- **Category:** industry-titans
- **Price:** Free
- **Endpoint:** https://edge.vinkius.com/vk_preview_PXJrbeq9A0WnBpVI6VWgAL2icGxZ55Dkrrumb7Lc/ai-agent-connect
- **Tags:** low-code, relational-database, business-apps, data-automation, custom-scripts, schema-management

## Description

This Connector lets you treat your Ninox database like a direct conversation with your AI. Instead of logging into a dashboard to manually move data between tables or write complex queries, you just tell your agent what needs to happen. You can ask it to find specific customers, update their status across multiple records at once, or even run those custom scripts you've already built. It handles the heavy lifting of navigating your schema so you don't have to remember every field name. Because Vinkius hosts this Connector, you can pull your entire database into your workspace and start managing your business apps without ever leaving your chat interface. It's like giving your AI a dedicated seat as your database admin. You can check your team's workspace access, pull reports on project statuses, or batch-update entries in seconds. It turns a manual, multi-tab process into a single command. You no longer have to worry about the friction of data entry or the complexity of relational logic. Your agent handles the technicalities of the Ninox platform so you can focus on the actual work of running your business. Whether you are looking to maintain high-fidelity data or just want to get insights faster, this connection bridges the gap between your data and your daily actions.

## Tools

### execute_ninox_script
Execute a Ninox script or query. This allows you to run your custom logic and advanced calculations through your AI.

### list_records
List records from a table. Retrieve multiple entries at once to analyze data or find specific items.

### update_record
Update a specific record. Change individual fields for a single entry without navigating the full UI.

### create_records
Create or update records in your tables. This lets you add new entries or modify existing ones with specific field data.

### delete_record
Delete a specific record. Use this to clean up your database by removing outdated or incorrect entries.

### get_database_schema
Get the database schema. This helps the AI understand your table structures and field types automatically.

### get_record
Get details for a specific record. Pull all the data for a single entry to review it in your chat.

### list_databases
List all databases in the team. See every database your team manages in a single list.

## Prompt Examples

**Prompt:** 
```
List all tables in my Ninox database ID 'db123'.
```

**Response:** 
```
I've retrieved your tables. You have 4 active structures including 'Invoices', 'Customers', and 'Inventory'. Which one would you like to see records for?
```

**Prompt:** 
```
Show me the schema and field definitions for the Customers table in database db_main.
```

**Response:** 
```
The Customers table in db_main has 8 fields: Name (text, required), Email (email), Phone (phone), Company (text), Status (choice: Active/Inactive/Lead), Revenue (number, currency), Created Date (date), and Notes (multiline text). There are 342 records currently in this table.
```

**Prompt:** 
```
Create a new record in the Orders table with customer Acme Corp, amount 4500, and status Pending.
```

**Response:** 
```
New record created successfully in the Orders table (Record ID: 1847). Customer: Acme Corp, Amount: $4,500.00, Status: Pending. The record was automatically timestamped with today's date and linked to the existing Acme Corp entry in your Customers table.
```

## Capabilities

### Update records across multiple tables
Modify existing data points or add new entries across your entire database using natural language.

### Run custom Ninox scripts
Execute your pre-built scripts and complex queries directly through your AI client.

### Pull full database schemas
Let your AI understand your table structures and field types automatically.

### List all team databases
View every database your team manages in a single, organized list.

### Create new records
Add new data entries with specific field metadata without filling out manual forms.

### Delete old entries
Remove outdated or incorrect records from any table to keep your data clean.

## Use Cases

### Updating customer status
An account manager asks the agent to mark all 'Pending' customers as 'Active' in the CRM, and the AI handles the batch update using `update_record`.

### Running custom scripts
A developer wants to run a specific script to calculate monthly revenue across three tables and asks the AI to `execute_ninox_script`.

### Batch record creation
An ops lead asks the AI to create 10 new project entries based on a list of names and dates, which the agent handles via `create_records`.

### Schema exploration
A new user asks the AI to explain what fields are in their 'Invoices' table to understand their data structure using `get_database_schema`.

## Benefits

- No more manual data entry: Use `create_records` to add data via chat instead of filling out forms. This saves you from tedious clicking and ensures your records are updated in real time without any manual friction.
- Faster report generation: Use `list_records` to pull data instantly for your team. You can grab specific entries for any table and have your AI summarize them in seconds, cutting out the time spent on manual exports.
- Automated logic: Run complex calculations instantly using `execute_ninox_script`. This lets your AI run the custom scripts you already built, handling complex math and data manipulation without you having to write a single line of code.
- Schema awareness: Let your agent understand your data structure using `get_database_schema`. Your AI will know exactly which fields exist and what they do, making it much easier to ask for specific data without getting errors.
- Centralized control: Manage multiple databases at once with `list_databases`. You can see every database your team manages in one view, allowing your AI to navigate your entire digital infrastructure with ease.
- Clean data: Keep your records accurate by using `update_record` and `delete_record` via chat. You can fix typos or remove old entries by simply telling your agent what to change, keeping your database pristine.

## How It Works

The bottom line is you get a direct text interface for your entire Ninox database.

1. Subscribe to the Ninox MCP on Vinkius.
2. Add your Personal Access Token and Team ID from your Ninox account settings.
3. Start asking your AI client to manage your records, check schemas, or run scripts.

## Frequently Asked Questions

**What can I do with the Ninox MCP?**
You can manage your entire Ninox database using natural language. This includes creating and updating records, running custom scripts, and pulling specific data for reports.

**How do I connect Ninox to my AI?**
Once you subscribe on Vinkius, you just need to provide your Ninox Personal Access Token and Team ID in your client settings to start the connection.

**Can I run my custom scripts?**
Yes, you can execute any native Ninox scripts or queries by simply asking your AI agent to run them for you.

**Does it work with my existing team databases?**
It does. The Connector can list all databases within your team so you can interact with any of them through your chat interface.

**Can I update multiple records at once?**
Yes, you can ask your agent to perform batch updates, like changing the status of multiple entries in a single command.

**How do I see my database structure?**
Your AI can pull the full database schema for any table, showing you all available fields and their types instantly.

**Is this good for business automation?**
It is designed specifically for that. It bridges the gap between your data and your daily actions by automating record management and script execution.

**Can my AI automatically find my Team ID for me?**
The Team ID is required during initial setup. You can find it in your browser URL when you are inside your Ninox workspace (e.g., `app.ninox.com/team/ABC123XYZ`).

**How do I find my Ninox Personal Access Token?**
Log in to your Ninox account at app.ninox.com, click the gear icon for Settings, and navigate to the **API** section to generate your unique secret token.

**Can I run native Ninox scripts via the AI?**
Yes! Use the `execute_ninox_script` tool. Provide your database ID and the script body, and the AI will perform the operation using Ninox's native server-side scripting engine.