# Xata (Serverless DB) MCP for AI Agents AI Agent Connect > Xata (Serverless DB) lets you manage your serverless database infrastructure directly through your AI agent. Instead of jumping between your terminal and a dashboard, you can list organizations, create projects, manage branches, and run SQL queries using natural language. It gives your agent the ability to handle the heavy lifting of data operations, from monitoring project limits to executing complex batches of SQL commands. ## Overview - **Category:** databases - **Price:** Free - **Endpoint:** https://edge.vinkius.com/undefined/ai-agent-connect - **Tags:** serverless, sql, database-migration, relational-data, cloud-database, data-ops ## Description Xata (Serverless DB) lets you manage your serverless database infrastructure directly through your AI agent. Usually, handling database tasks means jumping between your code editor and a web dashboard to check project settings, manage team permissions, or run manual queries. This Connector changes that by letting you handle these operations through natural conversation. You can have your agent pull branch metrics, check your project limits, or even run a batch of SQL queries to migrate data without ever leaving your workspace. It turns your AI into a capable database administrator that understands your Xata environment. By connecting this to your workflow through Vinkius, you get a way to handle infrastructure tasks as part of your normal conversation. It handles the tedious stuff like managing team invitations or rotating credentials so you can stay focused on writing code. You're not just running queries; you're managing the entire lifecycle of your serverless data. ## Tools ### request_organization_deletion Start the process to delete an organization. Use this for decommissioning old accounts. ### delete_project Delete a project from your organization. This is useful for cleaning up old test data. ### execute_sql_batch Run a batch of SQL queries in a single transaction. It's perfect for complex data migrations. ### execute_sql Run a single SQL query against a specific branch. Use this for quick data retrieval or updates. ### get_branch_credentials Retrieve the credentials for a specific branch. This is helpful for connecting external apps. ### get_branch_metrics Get the performance metrics for a branch. Use this to monitor your database health. ### get_branch Get the specific details of a database branch. This helps you verify branch configurations. ### get_organization Retrieve the details of an organization. Use this to check your account status. ### get_project_limits See the resource limits for your projects. This helps you stay within your plan's boundaries. ### get_project Get the specific details of a project. Use this to verify project settings. ### list_branches List all branches within a project. This helps you see what environments are available. ### list_images List the available images for your infrastructure. This helps you see what's supported. ### list_instance_types List the instance types available in a specific region. Use this to plan your scaling. ### list_invitations See all current organization invitations. This helps you track pending team members. ### list_members List all members in an organization. Use this to audit your team access. ### list_organizations List all organizations in your account. This helps you see your entire portfolio. ### list_projects List all projects within a specific organization. Use this to find your different databases. ### list_regions List the available regions for your data. Use this to plan your global deployment. ### remove_member Remove a member from an organization. Use this to offboard team members quickly. ### resend_invitation Send a new invitation to a team member. Use this if someone didn't get the original email. ### rotate_branch_credentials Rotate branch credentials to improve security. Use this to refresh keys without manual updates. ### update_project Update the details of a project. Use this to change project names or configurations. ### create_project Create a new project in your Xata account. This helps you organize different environments. ### delete_branch Remove a database branch when it's no longer needed. This keeps your workspace clean. ### delete_invitation Remove an organization invitation that's no longer valid. This helps keep your team list accurate. ### send_invitation Send a new invitation to join an organization. This is the primary way to add new team members. ### update_branch Update the details of an existing branch. Use this to modify branch settings. ### update_organization Update the details of an organization. Use this to change your account name or settings. ### create_branch Create a new database branch. This allows you to isolate different development environments. ### create_organization Create a new organization. Use this to group multiple projects and teams together. ## Prompt Examples **Prompt:** ``` Can you show me the performance metrics for the production branch? ``` **Response:** ``` I've pulled the latest metrics for your 'production' branch: | Metric | Value | | :--- | :--- | | **Avg Latency** | 142ms | | **Read Throughput** | 2.4k req/s | | **Write Throughput** | 450 req/s | | **Active Connections** | 128 | Everything looks healthy. Would you like me to check the project limits as well? ``` **Prompt:** ``` Create a new database branch called 'feature-auth-test' in the main project. ``` **Response:** ``` I've successfully created the new branch for you. * **Branch Name:** `feature-auth-test` * **Project:** `main-project` Is there anything else you need to do with this new environment? ``` **Prompt:** ``` Run this SQL query on the staging branch: SELECT * FROM users WHERE last_login < '2023-01-01'; ``` **Response:** ``` Query executed successfully on the 'staging' branch. I found 42 users who haven't logged in since the start of the year. Would you like me to export this list or run another query? ``` ## Capabilities ### Run SQL queries Execute commands against specific branches to fetch or modify data. ### Batch SQL execution Run multiple queries in a single transaction for faster data migration. ### Create database branches Spin up new environments for testing or development. ### Monitor project limits Check your resource usage and limits to avoid hitting caps. ### Manage team access Send invitations and manage members within your organization. ### Retrieve branch metrics Get a snapshot of performance and data for specific branches. ## Use Cases ### Automated Data Migrations A developer needs to move records between environments. They ask the agent to use `execute_sql_batch` to run multiple queries in a single transaction to ensure data integrity. ### Infrastructure Health Checks A DevOps engineer wants to see how a specific branch is performing. They ask the agent to use `get_branch_metrics` to pull a quick report on performance. ### Rapid Environment Provisioning A team lead needs a new sandbox for a feature test. They ask the agent to use `create_branch` to spin up an isolated database environment immediately. ### Team Onboarding and Audits An admin needs to check who has access to a project. They ask the agent to use `list_members` to generate a list of current organization members. ## Benefits - Run complex SQL queries using `execute_sql` without leaving your editor to fetch or update data instantly. - Manage database environments with `create_branch` and `delete_branch` to keep your dev and prod environments isolated. - Monitor infrastructure health with `get_branch_metrics` to identify performance issues before they affect users. - Stay within your plan's limits by checking `get_project_limits` to avoid unexpected downtime or overages. - Handle team management with `send_invitation` and `list_members` to manage permissions without manual dashboard clicking. - Execute migrations safely using `execute_sql_batch` to run multiple queries in a single transaction. ## How It Works The bottom line is you get a way to manage your entire Xata database infrastructure using only natural language. 1. Subscribe to the Xata (Serverless DB) MCP on Vinkius. 2. Provide your Xata API Key in your AI client's configuration. 3. Ask your agent to perform tasks like 'Create a new project called Staging' or 'Show me the metrics for the main branch.' ## Frequently Asked Questions **Can I use Xata (Serverless DB) to run SQL queries via my AI agent?** Yes, you can run queries on specific branches using natural language. Your agent can fetch data, update records, or run complex batches for you. **How does Xata (Serverless DB) help with database migrations?** It allows you to run batches of SQL queries in a single transaction. This makes it much easier to migrate data safely without manual steps. **Can my AI agent manage my team members in Xata?** Yes, the Connector includes tools to send invitations, list members, and manage organization access, so you can handle onboarding through conversation. **Can I check my project limits with Xata (Serverless DB)?** Yes, your agent can check your project limits to show you how much of your resource plan you have left. **How do I create new database branches using Xata (Serverless DB)?** You can simply ask your agent to create a new branch for a specific project. It handles the creation and provides you with the details instantly. **Can Xata (Serverless DB) help with database security?** Yes, it can rotate branch credentials for you. This helps keep your environment secure without you having to manually update keys in multiple places. **Can I execute raw SQL queries on my Xata branches?** Yes! You can use the `execute_sql` tool to run any valid SQL statement against a specific database branch. For multiple statements, use `execute_sql_batch`. **How do I check the performance or usage of a specific database branch?** Use the `get_branch_metrics` tool. It provides real-time insights into the operational status and usage metrics of your targeted database branch. **Is it possible to manage team access and invitations through the AI?** Absolutely. You can use `list_members` to see who has access, and `send_invitation` to invite new collaborators to your organization directly.