aggregate_records
ChatGPTPerform aggregation operations (sum, avg, min, max, count, count_distinct) on a field in a table. Optionally group results by another field.
Overview
Zite helps users inspect, query, analyze, and update their private workspace data through ChatGPT, including databases, tables, fields, records, aggregations.
Tools
bulk_create_records
ChatGPTCreate multiple records at once. Much more efficient than creating records one at a time. Complex field types have specific value encodings documented in records. When describing this action to users, refer to databases and tables by their human-readable names, not their IDs. Example: To populate a countries table: { "baseId": "abc123", "tableId": "tbl456", "records": [ { "Country Name": "United States", "Population": 331000000, "Continent": "North America" }, { "Country Name": "China", "Population": 1400000000, "Continent": "Asia" }, { "Country Name": "Brazil", "Population": 214000000, "Continent": "South America" } ] }
bulk_update_records
ChatGPTUpdate multiple records at once. Each record object must include a recordId field to identify which record to update. Complex field types have specific value encodings documented in records. When describing this action to users, refer to databases and tables by their human-readable names, not their IDs.
count_records
ChatGPTCount the total number of records in a database table. Optionally filter to count only matching records.
create_database
ChatGPTCreate a new database with tables and fields. Use this to build structured data stores for any kind of information. Field templates are optional or required depending on field type, as documented in fields.template. When presenting the created database to users, include its URL as a clickable link. Example: To create a countries database: { "name": "World Countries", "tables": [{ "name": "Countries", "fields": [ { "name": "Country Name", "type": "single_line_text" }, { "name": "Population", "type": "number", "template": { "decimalPlaces": 0 } }, { "name": "GDP (USD)", "type": "currency", "template": { "currencySymbol": "$", "decimalPlaces": 2 } }, { "name": "Continent", "type": "single_select", "template": { "options": [ { "value": "africa", "label": "Africa" }, { "value": "asia", "label": "Asia" }, { "value": "europe", "label": "Europe" }, { "value": "north_america", "label": "North America" }, { "value": "south_america", "label": "South America" }, { "value": "oceania", "label": "Oceania" } ]}}, { "name": "Is UN Member", "type": "checkbox" } ] }] }
create_field
ChatGPTAdd a new field (column) to an existing table. Pass the field definition (name, type, and any required template) via the "field" argument. When describing this action to users, refer to databases and tables by their human-readable names, not their IDs.
create_record
ChatGPTCreate a new record (row) in a table. Provide field values as key-value pairs where keys are field IDs or field names. Complex field types have specific value encodings documented in record. When describing this action to users, refer to databases and tables by their human-readable names, not their IDs.
create_table
ChatGPTCreate a new table in an existing database. Define the table name and fields; each field template is optional or required depending on field type, as documented in fields.template. When describing this action to users, refer to databases by their human-readable names, not their IDs. When presenting the created table to users, include its URL as a clickable link.
delete_field
ChatGPTDelete a field (column) from a table. This will permanently remove the field and all its data from every record. When describing this action to users, refer to databases, tables, and fields by their human-readable names, not their IDs.
delete_record
ChatGPTDelete a record from a table. When describing this action to users, refer to databases and tables by their human-readable names, not their IDs.
delete_table
ChatGPTDelete a table from a database. This will permanently remove the table and all its records. When describing this action to users, refer to databases and tables by their human-readable names, not their IDs.
get_database
ChatGPTGet details about a specific database including its tables. When presenting databases and tables to users, include their URLs as clickable links.
get_record
ChatGPTGet a single record by its ID from a database table.
get_table_schema
ChatGPTGet the schema (fields) for a specific table in a database.
list_databases
ChatGPTList all databases you have access to. Returns database IDs, names, URLs, and timestamps. When presenting databases to users, include URLs as clickable links.
query_records
ChatGPTQuery records from a database table. Returns records with their field values.
update_field
ChatGPTUpdate a field's name, type, or template. Changing the field type may affect existing data. When describing this action to users, refer to databases, tables, and fields by their human-readable names, not their IDs.
update_record
ChatGPTUpdate an existing record. Only the fields you specify will be updated; other fields remain unchanged. Complex field types have specific value encodings documented in record. When describing this action to users, refer to databases and tables by their human-readable names, not their IDs.
update_table
ChatGPTUpdate a table's name. When describing this action to users, refer to databases and tables by their human-readable names, not their IDs.
Capabilities
Writes
Links
App Stats
19
Tools
ChatGPT
Platforms
Works with
ChatGPT
Data refreshed daily