convex-mcp

为 Azure Database for PostgreSQL 灵活服务器设置 Microsoft Entra ID（Azure AD）认证。当用户需要配置无密码认证、将 Azure 身份映射至 PostgreSQL 角色、授予数据库权限、设置托管身份访问权限、配置基于组的访问控制、排查认证失败问题，或从基于密码的认证迁移到 Entra ID 时，可使用此技能。

Convex MCP Server

Use the Convex MCP tools to interact with the database.

Workflow

•Get deployment: Run status first to get the deployment selector
•Explore schema: Use tables to see available tables and their schemas
•Browse data: Use data to paginate through documents in a table
•Custom queries: Use runOneoffQuery for read-only JavaScript queries

Available Tools

Tool	Purpose
`status`	Get deployment selector (run first)
`tables`	List tables with schemas
`data`	Paginate through table documents
`runOneoffQuery`	Execute read-only JS queries
`functionSpec`	Get metadata about deployed functions
`run`	Execute deployed Convex functions
`logs`	Fetch recent function execution logs

Example Queries

javascript

// runOneoffQuery: Count documents in a table
const count = await db.query("users").collect();
return count.length;

// runOneoffQuery: Filter documents
const active = await db.query("users")
  .filter(q => q.eq(q.field("status"), "active"))
  .collect();
return active;