| 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’” |
