Model Context Protocol (MCP) is an open standard that lets AI assistants securely connect to external data sources. With Softr’s MCP server, you can give AI tools like Claude, ChatGPT, or Cursor direct read and write access to your Softr databases — so you can query data, create records, manage tables, and more, all through natural language.Documentation Index
Fetch the complete documentation index at: https://docs.softr.io/llms.txt
Use this file to discover all available pages before exploring further.
MCP Server URL
Authentication
Softr’s MCP server supports two authentication methods. Both offer fine-grained permission control over what the AI tool can access.OAuth (Recommended)
OAuth is the simplest way to connect. Softr has pre-built OAuth integrations for the following AI tools:| AI Tool | OAuth Client ID |
|---|---|
| Claude (claude.ai) | db31b760-e758-4f52-b15b-93b0262a1290 |
| Cursor (cursor.com) | 4d2556b2-cfc8-4608-bd76-8dbe7e605f68 |
| ChatGPT (chatgpt.com) | aa73bf7b-c5b6-4031-b771-25108bf6c132 |
| Mistral AI (mistral.ai) | 522bfc02-e64f-43cd-87ef-552507ecb967 |
Open your AI tool's MCP settings
In Claude, Cursor, ChatGPT, or Mistral AI, navigate to the section where you add MCP servers or external connectors.
Enter the Client ID
When prompted for a Client ID, paste the value from the table above that corresponds to your AI tool. If asked for a Client Secret, leave it blank — Softr’s OAuth clients are public and do not require one.
Authenticate with Softr
Click Connect or Authorize. You will be redirected to Softr to log in and approve the requested permissions.
Personal API Token (PAT)
Use a Personal API Token if you are connecting a custom AI tool, building your own MCP client, or using any tool not listed above.Generate a Personal API Token
In your Softr account, go to Settings → API Tokens and create a new token. Select only the permissions your AI tool needs.
Permissions
Both OAuth and PAT support the same set of fine-grained permissions. Grant only what your AI tool actually needs.| Permission | What it allows |
|---|---|
databases.records:read | Read records from tables |
databases.records:write | Create, update, and delete records |
databases.schema:write | Create and modify databases, tables, and fields |
Available Tools
The Softr MCP server exposes 20 tools across three categories.Databases
| Tool | Description | Required permission |
|---|---|---|
list_databases | List all databases in your workspace. | databases.records:read |
get_database | Get details of a specific database. | databases.records:read |
create_database | Create a new database in a workspace. | databases.schema:write |
update_database | Update a database’s name or description. | databases.schema:write |
Tables
| Tool | Description | Required permission |
|---|---|---|
list_tables | List all tables in a database with record counts and timestamps. | databases.records:read |
get_table | Get a table’s full schema including all field definitions. | databases.records:read |
create_table | Create a new table with an initial set of fields. | databases.schema:write |
update_table | Update a table’s name or description. | databases.schema:write |
list_fields | List all fields in a table with their types and configuration. | databases.records:read |
create_field | Add a new field to a table. Supports 20 field types including text, number, select, date, attachment, linked record, and more. | databases.schema:write |
update_field | Update a field’s name or options. Field type cannot be changed. | databases.schema:write |
list_views | List saved views for a table. Views can be passed to list_records to apply saved filters and sorts. | databases.records:read |
Records
| Tool | Description | Required permission |
|---|---|---|
list_records | List records in a table with pagination. Optionally filter by a saved view. | databases.records:read |
search_records | Search records using filter conditions and sorting rules. | databases.records:read |
get_record | Get a single record by ID. | databases.records:read |
create_record | Create a single record in a table. | databases.records:write |
create_records | Batch create up to 100 records in a single operation. | databases.records:write |
update_record | Update fields on an existing record. | databases.records:write |
delete_record | Delete a single record. | databases.records:write |
delete_records | Batch delete up to 100 records in a single operation. | databases.records:write |
Example prompts
Once connected, you can interact with your Softr databases in natural language. Here are a few examples:- “List all databases in my workspace.”
- “Show me the last 10 records added to the Contacts table.”
- “Create a new record in the Projects table with name ‘Website Redesign’ and status ‘In Progress’.”
- “Search the Orders table for all records where status is ‘Pending’ and sort by created date descending.”
- “Add a new ‘Priority’ select field to the Tasks table with options Low, Medium, and High.”