Admin Tools

The Admin MCP server provides system administration, audit logging, and infrastructure management tools.

Access: Admin users only (RBAC enforced)

Infrastructure Tools

admin_system_postgres_raw_query

Execute raw SQL queries:

Input:
  query: string - SQL query to execute
  params?: array - Query parameters

Output: Query results as JSON

admin_system_postgres_list_tables

List all database tables:

Output: Table names and schemas

admin_system_postgres_health_check

Check PostgreSQL health:

Output: Connection status, version, uptime

admin_system_redis_get_key

Get Redis cache value:

Input:
  key: string - Cache key

Output: Cached value

admin_system_redis_set_key

Set Redis cache value:

Input:
  key: string - Cache key
  value: string - Value to store
  ttl?: number - TTL in seconds

Output: Confirmation

admin_system_redis_delete_keys

Delete multiple Redis keys:

Input:
  keys: string[] - Keys to delete

Output: Number of keys deleted

admin_system_redis_list_keys_by_pattern

Search Redis keys:

Input:
  pattern: string - Key pattern (e.g., "session:*")
  limit?: number - Max results

Output: Matching keys

admin_system_redis_clear_cache_by_pattern

Clear cache by pattern:

Input:
  pattern: string - Pattern to match

Output: Number of keys cleared

admin_system_milvus_list_collections

List vector collections:

Output: Collection names and stats

admin_system_milvus_get_collection_info

Get collection details:

Input:
  collection_name: string

Output: Schema, row count, index info

admin_system_infrastructure_health_check

Overall infrastructure health:

Output:
  postgres: status, latency
  redis: status, latency
  milvus: status, latency
  overall: healthy/degraded/down

User Management

admin_system_users_list_all

List all users:

Input:
  limit?: number - Page size (default: 50)
  offset?: number - Page offset

Output: User list with metadata

admin_system_users_get_by_id

Get user details:

Input:
  user_id: string

Output: User profile, sessions, activity

admin_system_users_update_properties

Update user properties:

Input:
  user_id: string
  updates: object - Properties to update

Output: Updated user

Audit Tools

admin_audit_get_user_activity

Query audit logs:

Input:
  user_id?: string
  email?: string
  start_date?: string (ISO 8601)
  end_date?: string (ISO 8601)
  event_type?: string
  action?: string
  success?: boolean
  limit?: number
  include_details?: boolean

Output: Audit events with optional details

admin_audit_get_user_chats

Get user chat history:

Input:
  user_id: string
  search_query?: string
  start_date?: string
  end_date?: string
  mcp_server?: string
  tools_used?: string[]
  session_id?: string
  failures_only?: boolean
  limit?: number

Output: Chat sessions and messages

admin_audit_get_login_history

Login/logout history:

Input:
  user_id?: string
  email?: string
  start_date?: string
  end_date?: string
  auth_type?: string
  failed_only?: boolean
  include_ip_analysis?: boolean
  limit?: number

Output: Login events with IP analysis

admin_audit_get_error_analysis

Error analysis and trends:

Input:
  start_date?: string
  end_date?: string
  error_type?: string
  user_id?: string
  include_stack_traces?: boolean
  group_by?: 'type' | 'user' | 'day'
  limit?: number

Output: Error summary and trends

admin_audit_get_usage_statistics

Comprehensive usage analytics:

Input:
  start_date?: string
  end_date?: string
  time_granularity?: 'hour' | 'day' | 'week'
  include_user_breakdown?: boolean
  include_mcp_usage?: boolean
  include_geo_analysis?: boolean
  top_n?: number

Output: Usage metrics and breakdowns

LLM Metrics

admin_llm_usage_metrics

Token usage and costs:

Input:
  start_date?: string
  end_date?: string
  group_by?: 'provider' | 'model' | 'user'
  user_id?: string
  provider_type?: string
  limit?: number

Output: Token counts, costs, latency

admin_llm_routing_recommendations

Model routing suggestions:

Input:
  min_sample_size?: number

Output:
  cost_recommendations: best models for cost
  speed_recommendations: best for latency
  reliability_recommendations: best uptime

admin_llm_provider_status

Provider health status:

Output: Per-provider health, recent metrics

System Testing

admin_full_system_test

Comprehensive platform test:

Input:
  include_slow_tests?: boolean
  include_azure_tests?: boolean
  include_gcp_tests?: boolean
  verbose?: boolean

Output: Test results for all components

admin_system_check

Quick health summary:

Output: User-friendly health status

Checkpoint/Undo

mcp_action_log

List undoable actions:

Input:
  limit?: number
  user_id?: string
  mcp_server?: string
  action_type?: string

Output: Recent actions with undo capability

mcp_undo

Undo a specific action:

Input:
  action_id: string

Output: Undo result

mcp_action_checkpoint

Create a named checkpoint:

Input:
  name: string
  user_id?: string

Output: Checkpoint ID

mcp_list_checkpoints

List checkpoints:

Input:
  user_id?: string

Output: Checkpoints with TTL