> ## 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'"          |