Looker Admin MCP
MCP server for Looker administration. Provides 60+ admin tools for user, group, role, schedule, alert, and content access management through the Model Context Protocol (MCP).
Note: This server focuses on administration tasks, complementing Google's MCP Toolbox for Databases which handles analytics and data querying.
Features
| Category | Tools | Operations |
|---|---|---|
| User Management | 9 | CRUD, role assignment |
| Group Management | 9 | CRUD, membership |
| Role Management | 11 | Roles, permissions, model sets |
| Scheduled Plans | 8 | CRUD, run-once |
| Alerts | 7 | CRUD, follow/unfollow |
| Content Access | 8 | Folders, permissions |
| System | 8 | Sessions, user attributes |
Safety
Destructive operations (delete_user, delete_group, delete_role, etc.) require confirm=True parameter to execute.
# Example: Delete a user
delete_user(user_id=123) # Returns warning, doesn't delete
delete_user(user_id=123, confirm=True) # Actually deletes
Prerequisites
- Python 3.11+
- uv (Python package manager)
- Docker Desktop (Recommended)
Quick Start
-
Clone and setup:
git clone <repository-url> cd looker-mcp uv venv && source .venv/bin/activate uv pip install -e . -
Configure credentials:
cp .env.example .env # Edit .env with your Looker credentials -
Build Docker image:
./docker-build-run.sh build
MCP Client Configuration
Add to your client's MCP config (e.g., .cursor/mcp.json):
{
"mcpServers": {
"looker-admin": {
"command": "docker",
"args": [
"run", "--rm", "-i",
"-e", "MCP_MODE=stdio",
"-e", "LOOKERSDK_BASE_URL=${.env:LOOKERSDK_BASE_URL}",
"-e", "LOOKERSDK_CLIENT_ID=${.env:LOOKERSDK_CLIENT_ID}",
"-e", "LOOKERSDK_CLIENT_SECRET=${.env:LOOKERSDK_CLIENT_SECRET}",
"-e", "LOOKERSDK_VERIFY_SSL=${.env:LOOKERSDK_VERIFY_SSL}",
"looker-mcp:latest"
]
}
}
}
Available Tools
User Management (9 tools)
looker_me- Get current authenticated userlist_users- List all users with paginationsearch_users- Search by email, name, statusget_user- Get user detailscreate_user- Create new userupdate_user- Update user infodelete_user- Delete user (requires confirm=True)get_user_roles- Get user's rolesset_user_roles- Assign roles to user
Group Management (9 tools)
list_groups- List all groupssearch_groups- Search groups by nameget_group- Get group detailscreate_group- Create new groupupdate_group- Rename groupdelete_group- Delete group (requires confirm=True)list_group_users- List members in groupadd_user_to_group- Add user to groupremove_user_from_group- Remove user from group
Role Management (11 tools)
list_roles- List all rolesget_role- Get role details with permissionscreate_role- Create new roleupdate_role- Update roledelete_role- Delete role (requires confirm=True)list_permission_sets- List permission setsget_permission_set- Get permission set detailslist_model_sets- List model setsget_model_set- Get model set detailscreate_model_set- Create new model setlist_role_users- List users with a role
Scheduled Plans (8 tools)
list_scheduled_plans- List all schedulesget_scheduled_plans_for_dashboard- Get dashboard schedulesget_scheduled_plans_for_look- Get look schedulesget_scheduled_plan- Get schedule detailscreate_scheduled_plan- Create new scheduleupdate_scheduled_plan- Update scheduledelete_scheduled_plan- Delete schedule (requires confirm=True)run_scheduled_plan_once- Run schedule immediately
Alerts (7 tools)
search_alerts- Find alertsget_alert- Get alert detailscreate_alert- Create new alertupdate_alert- Update alertdelete_alert- Delete alert (requires confirm=True)follow_alert- Subscribe to alertunfollow_alert- Unsubscribe from alert
Content Access (8 tools)
list_folders- List foldersget_folder- Get folder detailsget_folder_children- Get folder contentsget_folder_ancestors- Get folder hierarchysearch_folders- Search foldersget_content_metadata_access- Get permissionsupdate_content_metadata_access- Set permissionsget_content_access- Get detailed access rules
System Admin (8 tools)
list_user_sessions- List active sessionsdelete_user_session- Kill session (requires confirm=True)list_user_attributes- List user attributesget_user_attribute- Get attribute detailsget_user_attribute_values- Get user's attribute valuesset_user_attribute_value- Set attribute valueget_api_versions- Get API versionsget_looker_version- Get Looker instance version
Project Structure
src/looker_admin_mcp/
├── client/
│ ├── sdk.py # SDK initialization
│ └── models.py # TypedDicts for responses
├── server/
│ ├── looker.py # Main server + error handling
│ ├── main.py # Entry point
│ └── transports.py # Stdio/SSE transport
└── tools/
├── user.py # User management (9 tools)
├── groups.py # Group management (9 tools)
├── roles.py # Role management (11 tools)
├── schedules.py # Scheduled plans (8 tools)
├── alerts.py # Alert management (7 tools)
├── content_access.py # Folder/permissions (8 tools)
└── system.py # System admin (8 tools)
Environment Variables
LOOKERSDK_BASE_URL=https://your-looker-instance.com
LOOKERSDK_CLIENT_ID=your_client_id
LOOKERSDK_CLIENT_SECRET=your_client_secret
LOOKERSDK_VERIFY_SSL=true
LOOKERSDK_TIMEOUT=120 # Optional
Complementary Tools
This server handles administration. For analytics/data:
- Google MCP Toolbox - Query data, explore models, create dashboards