Ragic
Ragic is a web-based database builder that allows users to create and manage databases as easily as creating a spreadsheet.
Verdict
Common use cases
- Check inventory levels during order review
- Pull customer history before sales calls
- Verify project task status in standups
- Find vendor contact details mid-conversation
- Review past support tickets for context
Integration
- Vendor
- Ragic
- Category
- other
- Auth
- API_KEY
- Tools
- 1
- Composio slug
ragic
Tools
- Search Records
Search records
Setup
Setup guide
- 11. In Switchy, open Settings and navigate to the Integrations page. 2. Find Ragic in the MCP directory and click Connect. 3. Log into your Ragic account and go to Account Settings, then API Access. 4. Generate a new API key and copy it. 5. Paste the key into Switchy's connection dialog and click Authorize. 6. Open any Space and type '@Ragic search records in [sheet name]' to test the connection. 7. If the search returns results, the integration is live. 8. To invoke Ragic in a conversation, @mention it followed by your search query and the sheet you want to query. 9. The MCP will return matching records with field values you can reference in your discussion.
What teammates see: by default, memories from Ragic are scoped to the Space (PROJECT visibility) - you can mark any memory PRIVATE or share it ORG-wide.
Works well with
Top models
Compatibility data appears once enough Spaces have used this MCP together with a given model.
How Switchy teams use it
Starter prompts
Check Stock Availability
@Ragic search the Inventory sheet for product SKU 'ABC-123' and show me the current quantity on hand and reorder threshold.Open in a Space →
Retrieve Customer Details
@Ragic search the Customers sheet for 'Acme Corp' and return their contact info, account manager, and last interaction date.Open in a Space →
Find Open Tasks
@Ragic search the Project Tasks sheet for all records where status is 'In Progress' and milestone is 'Q1 Launch'.Open in a Space →
Look Up Vendor Info
@Ragic search the Vendors sheet for 'Global Supplies Inc' and show me their payment terms, primary contact, and phone number.Open in a Space →
Review Support History
@Ragic search the Support Tickets sheet for all records where customer email is 'support@example.com' and show me the ticket subject and resolution status.Open in a Space →
Example outputs
Illustrative - representative of the model's voice and quality, not literal recordings.
@Ragic search for all customer records where status is 'active' and last contact date is within the past 30 days
Found 47 active customer records with recent contact. Top results include: Acme Corp (last contact: 3 days ago, account manager: Sarah Chen), TechStart Inc (last contact: 12 days ago, account manager: Mike Torres), and Global Solutions Ltd (last contact: 18 days ago, account manager: Emma Watson). All records show engagement scores above 75. The search covered your Customer Management sheet and filtered by the status and date fields you specified.
This example shows basic filtering across Ragic's spreadsheet-database structure. The MCP requires your API key to access your specific Ragic account's sheets. Search performance depends on your sheet size and field indexing—complex queries on large datasets may take several seconds to return.
@Ragic find all project records where deadline is before next Friday and completion percentage is less than 80%
Located 12 at-risk projects matching your criteria. Critical items: Website Redesign (deadline: Thursday, 62% complete, owner: Design Team), API Integration Phase 2 (deadline: Wednesday, 71% complete, owner: Dev Team), Q4 Marketing Campaign (deadline: Friday, 55% complete, owner: Marketing). All projects are flagged in your Project Tracker sheet with their current blockers and assigned owners visible.
Demonstrates date-based filtering and numeric comparisons—useful for deadline monitoring and progress tracking. The MCP reads your existing Ragic sheet structure, so field names must match exactly (case-sensitive). Results reflect your sheet's current state at query time; no automatic refresh or alerting.
@Ragic search inventory records for items where stock level is below reorder point, then summarize which suppliers we need to contact
Found 8 items below reorder threshold. Supplier breakdown: TechParts Ltd needs orders for 3 SKUs (capacitors, resistors, LED arrays—total estimated restock: $2,400), Component World for 2 SKUs (microcontrollers, sensors—$1,800), and Local Electronics for 3 SKUs (cables, connectors, switches—$600). All items are flagged as 'Low Stock' in your Inventory Management sheet. Recommended action: prioritize TechParts order due to lead time of 14 days.
Shows how the AI can synthesize Ragic data into actionable insights by grouping results and adding context. The MCP only retrieves data—it cannot place orders or update stock levels. You'll need to manually trigger reorders in your procurement system or add write-capable MCPs for automation.
Use-case deep-dives
When Ragic works for small support teams tracking cases
A 3-person support team uses Ragic to log customer issues in a shared database. During a call, an agent needs to pull up a customer's previous tickets to see if the billing question has come up before. The Ragic MCP's single search tool handles this well: the agent asks Switchy to search by customer email, gets the last 5 tickets, and references them without leaving the conversation. The API key auth means setup takes under a minute. The limitation is speed—if your Ragic database has more than 10,000 records, search can lag 3-4 seconds, which breaks flow on live calls. If you're under that threshold and your team already uses Ragic for structured data entry, this MCP turns your database into a conversational lookup layer. Worth the 60-second setup if you're hitting Ragic manually more than twice a day.
Ragic MCP for real-time stock queries in small retail ops
A 5-person e-commerce team tracks product inventory in Ragic. During a wholesale inquiry call, the sales rep needs to confirm stock levels for 3 SKUs without opening a browser tab. The Ragic MCP lets them ask Switchy to search by product code and get current quantities in under 2 seconds. The single-tool design is a feature here—there's no update or write risk, so the rep can't accidentally change stock counts mid-call. The trade-off is manual sync: if your inventory moves fast (more than 50 updates a day), Ragic's refresh lag means the MCP might show stale data. This works if your stock changes are batched (end-of-day updates) and your team is already committed to Ragic as the source of truth. Skip it if you need sub-minute accuracy or if your inventory lives in Shopify or a dedicated WMS.
When Ragic MCP helps solo consultants pull project hours
A solo consultant logs billable hours in Ragic, one row per client session. At month-end, they need to pull all hours for a specific client to generate an invoice. The Ragic MCP's search tool lets them ask Switchy for all records matching the client name, then copy the results into their invoice template. The API key auth means no OAuth dance, and the single tool keeps the scope narrow—there's no risk of accidentally editing past entries. The downside is formatting: Ragic returns raw field values, so if your timesheet has nested categories or calculated totals, you'll still need to open Ragic to see the summary. This MCP is worth it if you're logging 20+ sessions a month and your Ragic schema is flat. If you need aggregation or pivot views, you're better off exporting a CSV once a week.
Frequently asked
What does the Ragic MCP do in Switchy?
It lets your team search records across your Ragic databases directly from Switchy's AI workspace. Instead of logging into Ragic's web interface or writing API calls, you ask questions in natural language and the MCP queries your sheets, returning matching records. Useful for pulling customer data, inventory lookups, or any structured info you store in Ragic without context-switching.
Do I need admin access to connect Ragic?
You need an API key from your Ragic account, which any user can generate from their account settings. Admin privileges aren't required unless your Ragic workspace restricts API access at the account level. The MCP inherits whatever read permissions your API key has, so if you can't see a sheet in Ragic, the MCP can't search it either.
Can the Ragic MCP create or update records?
No. This integration only searches existing records. If you need to write data back to Ragic—adding rows, editing fields, or deleting entries—you'll have to do that in Ragic's UI or build a custom script against their API. The MCP is read-only by design, which keeps things safe for exploratory queries.
How is this different from just using Ragic's search bar?
Ragic's native search works fine if you know which sheet to look in and what field names to filter on. The MCP lets you ask fuzzy questions across multiple sheets without remembering exact column labels, and it surfaces results alongside data from your other connected tools in one Switchy thread. You trade precision for speed and context.
Who on the team should connect the Ragic MCP?
Whoever owns your Ragic account or has the broadest read access. Since the MCP uses a single API key, everyone in your Switchy workspace will query Ragic with that key's permissions. If you have sensitive sheets, connect with a restricted user account or accept that the whole team sees what that key can see.