otherapi_key

AnyDB

AnyDB is a flexible collaborative database platform for organizing records, files, sharing, and automated workflows.

Verdict

AnyDB is a flexible database platform that stores structured records in hierarchical trees. This MCP lets your team read, create, update, and search AnyDB records directly from Switchy Projects. @mention it to pull data from your team's databases, duplicate record subtrees, or create new entries without opening the AnyDB interface. Most useful for teams that maintain knowledge bases, project trackers, or inventory systems in AnyDB and want AI to query or update them on the fly. Requires an API key with read-write access; deletes are permanent and need explicit confirmation.

Common use cases

  • Query project status from a tracker database
  • Duplicate record templates for new initiatives
  • Search knowledge base articles by keyword
  • Create task records from meeting notes
  • Archive completed records to recycle bin

Integration

Vendor
AnyDB
Category
other
Auth
API_KEY
Tools
9
Composio slug
any_db

Tools

  • Copy Record

    Duplicate an AnyDB record and its child-record subtree, optionally into another database or parent. attachments_mode controls file attachments only.

  • Create Record

    Create a record in an AnyDB database, optionally attaching it to a parent and setting cell content.

  • Delete Record Permanently
    destructive

    Permanently delete one AnyDB record. This operation is irreversible and requires explicit confirmation.

  • Get Record

    Fetch one AnyDB record by ID, including its metadata and cell content.

  • List Databases

    List databases in an AnyDB team and return root and recycle-bin IDs used by record workflows.

  • List Records

    Return one page of record summaries from a database, optionally constrained by parent or template.

  • List Teams

    List AnyDB teams available to the connected account, including the IDs needed to discover databases.

  • Search Records

    Search a database for records matching a keyword, with caller-controlled offset and limit.

  • Update Record

    Update an AnyDB record's name, lock state, parent, user/group assignees, or cell content.

Setup

Setup guide

  1. 11. In Switchy, open Settings and navigate to the Integrations tab. 2. Find AnyDB in the MCP directory and click Connect. 3. You'll be prompted to paste an API key — generate one in your AnyDB account settings under API Access. 4. Grant the key read and write permissions for the databases your team needs. 5. Paste the key into Switchy and click Authorize. 6. To test, open any Project and type '@AnyDB list my teams' — you should see a list of your AnyDB teams and their IDs. 7. Once confirmed, use '@AnyDB list databases in team <ID>' to discover database IDs, then '@AnyDB list records in database <ID>' to fetch entries. 8. All record operations require database and record IDs, which you can retrieve with list or search commands first.

What teammates see: by default, memories from AnyDB are scoped to the Project (PROJECT visibility) - you can mark any memory PRIVATE or share it ORG-wide.

Works well with

Top models

Compatibility data appears once enough Projects have used this MCP together with a given model.

How Switchy teams use it

Not enough Projects yet to publish anonymised usage stats (we require ≥ 50 Projects per week).

Starter prompts

List All Databases

@AnyDB list all databases across my teams and show their names and root record IDs.

Search Knowledge Base

@AnyDB search the 'Product Docs' database for records containing 'API authentication' and return the top five results with summaries.

Create Task Record

@AnyDB create a new record in the 'Sprint Tasks' database with title 'Refactor login flow' and set the status cell to 'To Do'.

Duplicate Project Template

@AnyDB copy the record 'Q4 Campaign Template' and all its child records into the 'Active Projects' database under the 'Marketing' parent.

Fetch Record Details

@AnyDB get the record with ID <record_id> from the 'Client Accounts' database and show me all its cell values and attachments.

Example outputs

Illustrative - representative of the model's voice and quality, not literal recordings.

Prompt

@AnyDB search our customer feedback database for all records mentioning 'onboarding' in the last month and summarize the top 3 pain points

Output

Found 47 records matching 'onboarding' in the Customer Feedback database. The three most frequently mentioned pain points are: (1) unclear documentation during initial setup (mentioned in 18 records), (2) difficulty connecting third-party integrations in the first week (14 records), and (3) confusion about team permission levels when inviting new users (11 records). The search covered records created between December 15, 2024 and January 15, 2025. This is an illustrative example; actual results depend on your database structure and record content.

Notes

This example combines AnyDB's search capability with AI synthesis to extract actionable insights from unstructured feedback. Requires read access to the target database. Search is keyword-based, not semantic, so results depend on exact term matches in record cells. Large result sets may require pagination through multiple API calls.

Prompt

@AnyDB create a new project record in our Roadmap database called 'Q2 Mobile Redesign' with owner set to Sarah Chen and status set to Planning

Output

Created record 'Q2 Mobile Redesign' (ID: rec_8x4k9m2p) in the Roadmap database. Set the Owner cell to 'Sarah Chen' and Status cell to 'Planning'. The record is now visible at the root level of the database. You can attach child records (tasks, milestones) or update additional cells as needed. This illustrative example assumes your database has Owner and Status columns configured; actual cell names and types vary by your schema.

Notes

Demonstrates write operations that modify your live AnyDB workspace. The MCP maps natural-language cell names to your database's actual column structure, but you must know which fields exist. Creating records with invalid cell references will fail. This action is immediately visible to your team and cannot be undone via the MCP—use AnyDB's UI to delete mistakes.

Prompt

@AnyDB copy the 'Website Redesign' project record and all its subtasks into the Archive database, keeping file attachments intact

Output

Copied record 'Website Redesign' (rec_3n7j5k1w) and 12 child records into the Archive database (db_9m4x2p8q). All file attachments were preserved using attachments_mode='reference'. The original records remain in the active Projects database. The copied subtree is now located at the root level of Archive. This illustrative example shows a typical project archival workflow; actual child-record counts and attachment handling depend on your data structure.

Notes

Showcases AnyDB's hierarchical record model and bulk operations. Copying preserves parent-child relationships within the subtree but requires you to specify the destination database ID. The attachments_mode parameter controls whether files are duplicated or referenced—choose 'reference' to avoid storage bloat. Large subtrees (100+ records) may hit rate limits or timeout; consider batching for complex hierarchies.

Use-case deep-dives

Customer support ticket knowledge base

When AnyDB beats a wiki for support team lookup

A 6-person support team fields 40 tickets a day and needs fast access to troubleshooting steps stored in a shared database. AnyDB's Search Records tool lets the AI pull exact matches from your knowledge base without the team leaving Slack or their ticketing tool. The Copy Record workflow is useful when you onboard a new product line and need to duplicate an entire troubleshooting tree into a fresh database. This setup works until you hit about 5,000 records—after that, search latency climbs and you'll want a dedicated search index. If your knowledge base is mostly static and under 2,000 entries, AnyDB keeps your team moving without a second tab.

Sprint backlog grooming for product teams

AnyDB for lightweight project tracking at 3-8 people

A 5-person product team runs two-week sprints and stores epics, tasks, and design specs in AnyDB. The List Records and Get Record tools let the AI surface the next three unassigned tasks during standup or pull the full spec when a designer asks mid-conversation. Create Record handles quick task capture from Slack without opening the database UI. The workflow breaks down if you need complex dependencies or Gantt views—AnyDB is a flat hierarchy with optional parent-child links, not a full project graph. If your team ships features in linear sprints and doesn't need burndown charts, AnyDB keeps planning in the chat thread where the work already happens.

Sales pipeline contact enrichment

When AnyDB's record structure fits CRM overflow

A 4-person sales team uses a CRM for deals but stores meeting notes, competitive intel, and contact history in AnyDB because their CRM's notes field is a single text blob. The AI uses Get Record to pull the last three touchpoints with a prospect during deal review, and Create Record logs new notes after each call. The Copy Record tool is handy when a lead converts and you want to move their entire contact subtree into a won-deals archive database. This pattern works for teams closing 10-30 deals a month; beyond that, you need real CRM reporting and AnyDB becomes a shadow system. If your CRM is rigid and your sales motion is relationship-heavy, AnyDB gives the AI structured context without a Salesforce integration.

Frequently asked

What does the AnyDB MCP let me do in Switchy?

It connects your AnyDB workspace so AI agents can read, create, copy, and search records across your databases. The MCP exposes nine tools that handle everything from listing teams and databases to duplicating entire record subtrees with their attachments. You authenticate once with an API key, then any team member can query or modify AnyDB data through natural-language prompts.

Do I need admin access to connect AnyDB?

You need an AnyDB API key with read and write permissions for the databases you want the MCP to touch. AnyDB's API key system is account-scoped, so whoever generates the key determines which teams and databases Switchy can see. If your organization restricts API key creation to admins, you'll need one of them to set it up.

Can the MCP restore records I've deleted?

No. The Delete Record Permanently tool is irreversible and bypasses AnyDB's recycle bin entirely. The MCP can list records in the recycle bin using the root ID returned by List Databases, but it has no restore function. If you need to recover a deleted record, do it manually in the AnyDB web app before the retention window expires.

Why use this instead of AnyDB's web interface?

The MCP is faster for bulk operations and cross-database workflows that would take dozens of clicks in the UI. An agent can search three databases, copy matching records into a new parent, and update cell values in one prompt. The web interface is still better for visual layout work, complex filtering, or anything that needs human judgment on each record.

Who on my team should connect the AnyDB integration?

Whoever owns your team's AnyDB API keys or has permission to generate new ones. That person should create a dedicated key for Switchy rather than reusing a personal key, so you can rotate or revoke it without breaking other automations. Once connected, any Switchy team member can invoke the MCP through prompts, subject to your workspace access rules.

More other MCPs

See all other MCPs →

Data last verified 61 hours ago.Sources aggregated hourly to weekly. See docs/architecture/model-directory.md.