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