Table Create / Modify

Learn how to automatically create and modify table structures with AI through MCP clients.

Create Tables with AI

Describe your requirements in natural language in an MCP client and the AI will design the table structure and auto-add it to the NeoSQL ERD.

1

Request in MCP Client

Enter a table creation request in an MCP client such as Claude Desktop or Cursor.

Example: "Create a table to store member information. I need email, name, sign-up date, and status."

2

Auto-Reflect in NeoSQL

The table structure designed by AI is automatically added to the NeoSQL ERD. An ERD tab is created per MCP session so you can immediately review the results.

3

Execute DDL (Optional)

If the DDL Execute option is enabled in MCP settings, the table is immediately created in the actual database. When disabled, it is only added to the ERD and can be reviewed and manually applied from the NeoSQL UI.

Modify Tables with AI

Request modifications to existing table structures in natural language from an MCP client.

1

Request Modification in MCP Client

The AI automatically queries the current table structure via MCP, so you only need to provide the table name and the desired changes.

Example: "Add a deleted_at column to the users table for soft deletes."

2

Verify Changes in NeoSQL

The changes applied by AI are reflected in the NeoSQL table editor. Modified columns are highlighted.

Tip

You can also request multiple tables at once, such as "Create order, product, and payment tables needed for an e-commerce service all at once."