API Registry MCP Server

#!/usr/bin/env python3 """ Check which secrets Unity Catalog HTTP connections are using """ from databricks.sdk import WorkspaceClient w = WorkspaceClient() print("🔍 Checking HTTP Connections and their secret references...\n") try: # List all connections (may need catalog/schema context) catalogs = ["lucam_catalog", "luca_milletti"] # Add your catalogs for catalog in catalogs: print(f"📁 Catalog: {catalog}") try: schemas = list(w.schemas.list(catalog_name=catalog)) for schema in schemas: schema_name = schema.name if not schema_name: continue print(f" 📂 Schema: {schema_name}") # Try to list connections in this catalog.schema # Note: This may not work if the SDK doesn't support listing connections # Alternative: Query system tables except Exception as e: print(f" ⚠️ Could not list schemas: {e}") print() except Exception as e: print(f"❌ Error: {e}") print("\n💡 Alternative: Query the api_http_registry table directly") print("=" * 60) print("SELECT api_name, connection_name, auth_type, secret_scope") print("FROM your_catalog.your_schema.api_http_registry;") print("=" * 60) print("\nThis will show you which secret scope each API uses!")