Skip to main content

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.

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.

MCP Server URL

https://mcp.softr.io/mcp
Use this URL when adding Softr as an MCP server in your AI tool.

Authentication

Softr’s MCP server supports two authentication methods. Both offer fine-grained permission control over what the AI tool can access. OAuth is the simplest way to connect. Softr has pre-built OAuth integrations for the following AI tools:
AI ToolOAuth 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
When you connect via OAuth, you are taken to a Softr authorization screen where you choose which permissions to grant. Only the permissions you approve are available to the AI tool. You can revoke access at any time from your Softr account settings.
1

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.
2

Add the Softr MCP server URL

Enter https://mcp.softr.io/mcp as the server URL.
3

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.
4

Authenticate with Softr

Click Connect or Authorize. You will be redirected to Softr to log in and approve the requested permissions.
5

Select your permissions

On the Softr authorization screen, review the permissions and approve the ones you want to grant to the AI tool.

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.
1

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.
2

Configure your AI tool

Add the MCP server with Bearer token authentication:
{
  "mcpServers": {
    "softr": {
      "url": "https://mcp.softr.io/mcp",
      "headers": {
        "Authorization": "Bearer YOUR_API_TOKEN"
      }
    }
  }
}

Permissions

Both OAuth and PAT support the same set of fine-grained permissions. Grant only what your AI tool actually needs.
PermissionWhat it allows
databases.records:readRead records from tables
databases.records:writeCreate, update, and delete records
databases.schema:writeCreate and modify databases, tables, and fields
The databases.schema:write permission allows creating and modifying database structure (databases, tables, fields). Grant this only if you intend to let the AI tool make schema changes.

Available Tools

The Softr MCP server exposes 20 tools across three categories.

Databases

ToolDescriptionRequired permission
list_databasesList all databases in your workspace.databases.records:read
get_databaseGet details of a specific database.databases.records:read
create_databaseCreate a new database in a workspace.databases.schema:write
update_databaseUpdate a database’s name or description.databases.schema:write

Tables

ToolDescriptionRequired permission
list_tablesList all tables in a database with record counts and timestamps.databases.records:read
get_tableGet a table’s full schema including all field definitions.databases.records:read
create_tableCreate a new table with an initial set of fields.databases.schema:write
update_tableUpdate a table’s name or description.databases.schema:write
list_fieldsList all fields in a table with their types and configuration.databases.records:read
create_fieldAdd a new field to a table. Supports 20 field types including text, number, select, date, attachment, linked record, and more.databases.schema:write
update_fieldUpdate a field’s name or options. Field type cannot be changed.databases.schema:write
list_viewsList saved views for a table. Views can be passed to list_records to apply saved filters and sorts.databases.records:read

Records

ToolDescriptionRequired permission
list_recordsList records in a table with pagination. Optionally filter by a saved view.databases.records:read
search_recordsSearch records using filter conditions and sorting rules.databases.records:read
get_recordGet a single record by ID.databases.records:read
create_recordCreate a single record in a table.databases.records:write
create_recordsBatch create up to 100 records in a single operation.databases.records:write
update_recordUpdate fields on an existing record.databases.records:write
delete_recordDelete a single record.databases.records:write
delete_recordsBatch 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.”