> ## Documentation Index
> Fetch the complete documentation index at: https://developers.zite.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Supported MCP Tools

> What you can do with our MCP service

The Zite MCP's **Data** tool group, for querying and editing databases, tables, fields, and records in
natural language. App-building is the separate [Build](/mcp/overview) tool group. One connection:
`https://mcp.zite.com/mcp`.

| Tool | Description | Example Prompts |
| - | - | - |
| get\_table\_schema | Get the schema (fields) for a specific table in a database. | "What fields are in the Customers table?" / "Show me the columns in my Orders table" |
| query\_records | Query records from a table with optional filtering, sorting, and pagination. | "Show me all orders over \$500" / "Find customers in California sorted by signup date" |
| get\_record | Get a single record by its ID. | "Show me the details for order ABC123" / "Get the customer record with ID xyz" |
| get\_database\_schema | Get the full schema for a database, all of its tables and their fields, in a single call. | "Show me the structure of my Sales database" / "What tables and fields are in my CRM database?" |
| execute\_sql | Run a read-only SQL query over a database using human-readable table and field names. | "Run a SQL query for total revenue by month" / "Query the top 10 customers by number of orders" |
| create\_table | Create a new table in an existing database with specified fields. | "Add an Invoices table to my Sales database" / "Create a Tags table with name and color fields" |
| update\_table | Update a table's name. | "Rename the Clients table to Customers" / "Change the Products table name to Inventory" |
| delete\_table | Permanently delete a table and all its records. | "Delete the old Archived Orders table" / "Remove the Test table from my database" |
| create\_field | Add a new field (column) to an existing table. | "Add a phone number field to the Customers table" / "Add a priority dropdown to the Tasks table" |
| update\_field | Update a field's name, type, or configuration. | "Rename the 'price' field to 'unit\_price'" / "Change the status field options to include 'On Hold'" |
| delete\_field | Permanently delete a field and its data from all records. | "Remove the fax number field from Contacts" / "Delete the unused 'legacy\_id' column" |
| create\_record | Create a new record (row) in a table. | "Add a new customer named John Smith" / "Create a task to review the Q4 report" |
| update\_record | Update an existing record's fields. | "Mark order #1234 as shipped" / "Change the priority of the design task to high" |
| delete\_record | Delete a record from a table. | "Delete the duplicate customer entry" / "Remove the canceled order from the list" |
| bulk\_create\_records | Create multiple records at once (more efficient than one at a time). | "Add these 50 products to my inventory" / "Import this list of contacts into my CRM" |
| bulk\_update\_records | Update multiple records at once. | "Mark all overdue tasks as urgent" / "Update the status of these 10 orders to 'Processing'" |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.