# Ragic — how to use (mcp.ai)

Connect your Ragic account and use 7 tools for databases straight from your AI agent. Connect with your own API key. Ragic is a web-based database builder that allows users to create and manage databases as easily as creating a spreadsheet.

## Option A — via MCP (recommended)
Remote MCP endpoint (HTTP, streamable): `https://api.mcp.ai/p_ragic?ms=1787293500000`
Add it as a custom/remote MCP connector in your client (Claude, Cursor, VS Code…), then authenticate when prompted. Once connected, ask the agent to use the server's tools (e.g. `ragic_delete_entry`).

## Option B — via direct REST API
Base URL: `https://api.mcp.ai/api/ragic`
Auth: `Authorization: Bearer sk_live_…` — create a workspace API key at https://mcp.ai/settings/api-keys
Discover endpoints: `GET https://api.mcp.ai/api/ragic/_endpoints`

### Endpoints
- `POST https://api.mcp.ai/api/ragic/delete/entry` — Tool to delete an entry from a Ragic sheet. Use when you need to remove a specific record from a sheet by its record ID.
  - body: { server?: string, record_id: integer, tab_folder: string, sheet_index: integer, account_name: string }
- `POST https://api.mcp.ai/api/ragic/download/file` — Tool to download uploaded files, images, or email attachments from Ragic. Use the file reference returned from API responses (e.g., from record fields).
  - body: { server?: string, account_name: string, file_reference: string }
- `POST https://api.mcp.ai/api/ragic/get/action/buttons` — Tool to retrieve the list of available action buttons on a Ragic sheet. Returns action button IDs and names. Use category=massOperation to get buttons available for mass operations.
  - body: { server?: string, category?: string, tab_folder: string, sheet_index: integer, account_name: string }
- `POST https://api.mcp.ai/api/ragic/get/custom/print/report` — Tool to retrieve a custom print report for a Ragic record in various formats (pdf, png, docx). Use when you need to generate and download a formatted report using a specific template.
  - body: { server?: string, record_id: integer, fileFormat: string, tab_folder: string, sheet_index: integer, account_name: string, fileNameRefDomainId?: integer, ragicCustomPrintTemplateId: integer }
- `POST https://api.mcp.ai/api/ragic/get/entry` — Tool to retrieve a single entry from a Ragic sheet by its record ID. Use when you need to fetch specific record data including field values and optional subtable data.
  - body: { v?: string, info?: boolean, server?: string, comment?: boolean, history?: boolean, record_id: integer, subtables?: boolean, tab_folder: string, sheet_index: integer, account_name: string }
- `POST https://api.mcp.ai/api/ragic/get/record/as/pdf` — Tool to retrieve a PDF version of a Ragic record. Use when you need to export or download a record in PDF format. The PDF will contain the full record data in a formatted document.
  - body: { server?: string, record_id: integer, tab_folder: string, sheet_index: integer, account_name: string }
- `POST https://api.mcp.ai/api/ragic/search/records` — Search Records
  - body: { info?: boolean, limit?: integer, bbcode?: boolean, offset?: integer, server?: string, comment?: boolean, history?: boolean, listing?: boolean, reverse?: boolean, approval?: boolean, subtables?: boolean, ignoreMask?: boolean, sheet_path: string, account_name: string, conversation?: boolean, search_query: string, ignoreFixedFilter?: boolean }

## Example prompts
- "What can I do in Ragic?"
- "Show me a summary of my Ragic account"

## More
- Page: https://mcp.ai/ragic
- Agent spec (llms.txt): https://mcp.ai/ragic/llms.txt
- Postman collection: https://mcp.ai/ragic/postman.json