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.
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 all databases within a specified team. Returns database identifiers and names.
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
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 all teams (workspaces) accessible with the current authentication token. Teams are the top-level organizational unit in Ninox that contain databases.
update_record
Update field values of an existing record. Only the specified fields will be modified; other fields remain unchanged.
delete_records
Delete one or more records from a table by their IDs. This action is irreversible.
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 all files attached to a specific record. Returns file metadata including name, content type, size, and modification info.
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
Retrieve a single record by its ID from a specific table. Returns all field values and metadata for the record.
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 a file attached to a record. This action is irreversible.
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.
Manage workspaces, databases, tables, and records in Ninox's low-code database platform. Create, read, update, and delete records with filtering and upsert support. Execute Ninox query expressions and scripts to retrieve computed data and trigger custom logic. Upload, download, and delete file attachments on records. Retrieve and share views in PDF, HTML, CSV, XLSX, and JSON formats. Track changes across databases, tables, and records using sequence-based polling for synchronization workflows. Manage file and view sharing links.
Common questions about connecting Ninox to AI agents with Metorial.