• INVENTORY
  • MAPPING
  • CLEANUP
  • HUMAN

How to audit TiDB Cloud resources with your AI

Connect your AI to TiDB Cloud once. From there, your agent can scan your projects and instances to build a complete map of your database environment.

Ask AI about this page

Short answer

How can I audit my TiDB Cloud resources using AI?

Your AI uses the TiDB Cloud MCP to pull a list of all your projects and their associated instances. This gives you a real-time view of your distributed SQL footprint without manual clicking. You get a structured breakdown of every active resource in your account.

Audit outcomes

Where your data lands.

What your AI produces after scanning your account.

INVENTORY

Complete resource list

The AI gathers every project and instance currently running. You get a clear list of what exists in your TiDB Cloud account.

MAPPING

Project structure map

Your agent links specific instances back to their parent projects. This shows you exactly how your data is distributed across the organization.

CLEANUP

Identify unused resources

By reviewing metadata, your AI flags instances that might be redundant. You decide which ones to keep or decommission.

HUMAN

Manual policy review

The AI provides the data, but you must decide if the resource usage matches your company's security or cost policies.

The workflow

What your AI does when the request arrives.

The AI moves through your account hierarchy to gather the data you need.

  1. Scan projects

    The AI starts by looking at the top level of your account to find all active projects.

    list_projects

  2. Find instances

    Once it knows which projects exist, it looks inside each one to find the specific database instances.

    list_instances

  3. Fetch details

    The AI pulls specific metadata for a single project to get a deeper look at its configuration.

    get_project

  4. Build report

    The agent organizes the gathered project and instance data into a readable summary for you.

    list_projectslist_instances

Try it

Copy these to start.

Use these prompts to begin your audit.

Starting points

You can swap out specific project names or instance IDs in these prompts to target your search.

TiDB Cloud Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_sCYmPCgCjJyrcB49kPJ4COY6MnStt3VtJanpO1K0/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — TiDB Cloud capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "tidb-cloud-serverless-distributed-sql-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_sCYmPCgCjJyrcB49kPJ4COY6MnStt3VtJanpO1K0/mcp"
    }
  }
}
Copy into chat04

  • List all my TiDB Cloud projects and tell me how many instances are running in total.

  • Show me all the instances currently active in my 'Production-DB' project.

  • Get the metadata for my 'Analytics-Cluster' project and summarize its setup.

  • Map out my entire TiDB Cloud footprint by listing every project and its instances.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect TiDB Cloud once, then ask.

Just link your account once. Your credentials stay encrypted, and you can immediately start asking your AI about your database resources.

Connect TiDB Cloud to your AI

FAQ

How this task behaves

  • 01

    Can my AI delete a TiDB Cloud instance?

    No. This MCP only provides tools to read and list metadata. Your AI cannot modify or delete any resources.

  • 02

    Can the AI change my database configurations?

    No. The available tools are strictly for retrieving information about projects and instances.

  • 03

    How does the AI know which projects I own?

    It uses the list_projects tool to fetch the full list of projects associated with your connected account.

  • 04

    Can I use this to check my billing usage?

    No. The current tools only provide metadata for projects and instances, not financial or billing data.

  • 05

    Does the AI see my actual database tables?

    No. The AI only sees the metadata for the projects and instances themselves, not the data stored inside the tables.

  • More questions about TiDB Cloud? The Connector page answers them. See everything the TiDB Cloud Connector can do

Connect TiDB Cloud to Claude, Cursor, ChatGPT & more