Supported MCP Tools

What you can do with our MCP service

With the Zite MCP installed, you’re ready to discover how AI assistants can leverage these tools to create, query, and organize data in your databases.

These tools are designed to work together through natural language prompts, and combining them is where they truly shine. A single prompt can query your tables, create new records from what it finds, and update fields across multiple entries. Learning how these tools work helps you write more effective prompts that chain operations together to accomplish complex tasks.

Tool	Description	Example Prompts
list_databases	List all databases you have access to, including IDs, names, and timestamps.	”What databases do I have?” / “Show me all my databases”
get_database	Get details about a specific database including its tables.	”What tables are in my Sales database?” / “Show me the structure of the Inventory database”
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”
count_records	Count the total number of records in a table, with optional filtering.	”How many orders do I have?” / “Count the number of active subscribers”
get_record	Get a single record by its ID.	”Show me the details for order ABC123” / “Get the customer record with ID xyz”
aggregate_records	Perform aggregation operations (sum, avg, min, max, count, count_distinct) on a field, with optional grouping.	”What’s the total revenue by month?” / “What’s the average order value per customer?“
create_database	Create a new database with tables and fields.	”Create a database to track my book collection with title, author, and rating” / “Set up a project management database with tasks and deadlines”
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’”