Table-Building Machine (MCP tool usage)
I'm using Robert's Claude MCP tools to build 30+ tables for a new system. I wanted to test out what is possible and found a few limitations, such as being unable to create table reference fields (I tried, but they aren't right). With others, it cannot initially select all options (like adding Enum values) during the xano_create_table, but can alter them using the update_table_with_script afterwards. It also seemed to be unaware of Xano's default fields and tried to add a 'created_at' field more than once. So with a bit of training, my Claude session now has a set of rules for making all my tables, which it named itself as "Table-Building Machine". Here is its self-declared workflow: π€ Complete Table-Building Machine Workflow v4.0 π Enhanced Process for Every Table: 1. ποΈ Create Base TableUse xano_create_table (defaults to int primary key)Includes: id (int) + created_at (timestamp) - Xano auto-adds these 2. π Set Primary Key Type (if UUID needed)Use xano_update_table_with_script to change int id β uuid idSkip this step if sequential int is fine 3. π Add Standard Tracking Fieldslast_edited_at - timestamp (optional/nullable)last_edit_user_id - int (optional/nullable)Use xano_add_field_to_schema for these 4. β Add Regular Custom FieldsAll fields default to: required = false, nullable = trueOnly set required = true when you explicitly specify "(required)"Use xano_add_field_to_schema for: text, int, email, bool, decimal, etc. 5. π° Add Currency Fields (Β£)Use decimal field type for all monetary valuesEnsures accurate financial calculations without rounding errorsExamples: pay_rate, charge_rate, invoice_amount, total_amount 6. π Add URL FieldsUse text field type with URL validation patternApply regex pattern: ^https?:\/\/(www\.)?[-a-zA-Z0-9@:%._\+~#=]{1,256}\.[a-zA-Z0-9()]{1,6}\b([-a-zA-Z0-9()@:%_\+.~#?&//=]*)$Examples: website_url, logo_image, video_link, zoom_url 7. π· Add Image Fields Only β
NEW!Use xano_add_field_to_schema for image type onlyOther storage types (file, video, audio) must use script method 8. π― Add ENUM Fields (if any)Use xano_update_table_with_script methodAdd ENUM fields with proper values arrayEnsures values are stored correctly in Xano 9. π¦ Add Object Fields (if any)First add basic object field with xano_add_field_to_schema (type: object, style: list)Then use xano_update_table_with_script to add custom columnsSupports list configuration with multiple custom columns 10. π Add Storage Fields (file, video, audio) β
NEW!Use xano_update_table_with_script method for: file, video, audio typesXanoScript syntax: file ?field_name?, video ?field_name?, audio ?field_name?Image fields can be added earlier via regular method 11. π Table Creation CompleteComplete table with all 4 standard fields + custom fieldsProper field types, validation, and complex data structuresReady for YOUR manual table reference field additions 12. π Manual Table Reference Addition β
NEW STEP!YOU manually add table reference fields in Xano UIThese create proper dropdown relationships between tablesEssential for data integrity and user experience 13. π API Development ReadyAfter table references are complete, ready for CRUD API creationFull validation, relationships, and business logic support