{"_id":"@jerichosequitin/metabase-mcp","_rev":"5-74827b3c80d48de7f3e899e3361e0ece","name":"@jerichosequitin/metabase-mcp","dist-tags":{"latest":"1.1.7"},"versions":{"1.1.3":{"name":"@jerichosequitin/metabase-mcp","version":"1.1.3","keywords":["metabase","mcp","model-context-protocol","ai","claude","analytics","business-intelligence","sql"],"author":{"url":"https://github.com/jerichosequitin","name":"Jericho Sequitin"},"license":"MIT","_id":"@jerichosequitin/metabase-mcp@1.1.3","maintainers":[{"name":"jerichosequitin","email":"work@jerichosequitin.com"}],"homepage":"https://github.com/jerichosequitin/metabase-mcp#readme","bugs":{"url":"https://github.com/jerichosequitin/metabase-mcp/issues"},"bin":{"metabase-mcp":"build/src/index.js"},"dist":{"shasum":"f2de86311f759904d2de50df5db4151288821876","tarball":"https://registry.npmjs.org/@jerichosequitin/metabase-mcp/-/metabase-mcp-1.1.3.tgz","fileCount":165,"integrity":"sha512-6NG2hYr5PYFM7J8lJ36oSWaW9x6prFU64xyw31yWqVKDWaCotmgodhudcfNWD7AtlY/62OFaI/MdSF5Luaq42w==","signatures":[{"sig":"MEYCIQDzYhsJUyFfzdC1NmUQB/mMPuq6k/v7mAQHk3xCisRKjAIhAPZJas9ybLiofLYiJVQrquy0kZqofLPCDL/lEd6agJuZ","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":1332074},"type":"module","engines":{"node":">=18.0.0"},"gitHead":"032104769a973afd55fe07195dda918b67c347da","scripts":{"dev":"tsc && node build/src/index.js","lint":"eslint src/","test":"vitest run","build":"npm run validate && tsc && npm test && node -e \"require('fs').chmodSync('build/src/index.js', '755')\"","clean":"rm -rf build node_modules/.cache","start":"node build/src/index.js","watch":"tsc --watch","format":"prettier --write \"src/**/*.ts\"","prepare":"npm run build:fast && husky","version":"node scripts/sync-version.cjs && git add README.md manifest.json Dockerfile","lint:fix":"eslint src/ --fix","test:all":"./scripts/test-all.sh","validate":"npm run type-check && npm run lint && npm run format:check","dev:watch":"npm run build && concurrently \"tsc --watch\" \"nodemon --delay 2 build/src/index.js\"","inspector":"npx @modelcontextprotocol/inspector build/src/index.js","build:fast":"tsc && node -e \"require('fs').chmodSync('build/src/index.js', '755')\"","mcpb:build":"npm run build && node scripts/build-mcpb.cjs","test:watch":"vitest","type-check":"tsc --noEmit","build:clean":"rm -rf build && npm run build","format:check":"prettier --check \"src/**/*.ts\"","mcpb:validate":"echo 'MCPB validation - checking manifest structure' && node -e \"const fs = require('fs'); const manifest = JSON.parse(fs.readFileSync('manifest.json', 'utf8')); console.log('Manifest valid:', manifest.name, manifest.version);\"","test:coverage":"vitest run --coverage"},"_npmUser":{"name":"jerichosequitin","email":"work@jerichosequitin.com"},"repository":{"url":"git+https://github.com/jerichosequitin/metabase-mcp.git","type":"git"},"_npmVersion":"10.8.2","description":"A high-performance MCP server for Metabase analytics integration with response optimization and robust error handling","directories":{},"_nodeVersion":"20.19.6","dependencies":{"zod":"^3.25.0","xlsx":"https://cdn.sheetjs.com/xlsx-0.20.3/xlsx-0.20.3.tgz","dotenv":"^16.3.1","@types/xlsx":"^0.0.35","@modelcontextprotocol/sdk":"^1.23.0"},"_hasShrinkwrap":false,"devDependencies":{"husky":"^9.0.11","eslint":"^9.39.2","vitest":"^4.0.15","nodemon":"^3.0.2","prettier":"^3.2.5","typescript":"^5.3.3","@types/node":"^20.17.22","concurrently":"^8.2.2","typescript-eslint":"^8.49.0","@vitest/coverage-v8":"^4.0.15"},"_npmOperationalInternal":{"tmp":"tmp/metabase-mcp_1.1.3_1765648664967_0.6002475318167195","host":"s3://npm-registry-packages-npm-production"}},"1.1.4":{"name":"@jerichosequitin/metabase-mcp","version":"1.1.4","keywords":["metabase","mcp","model-context-protocol","ai","claude","analytics","business-intelligence","sql"],"author":{"url":"https://github.com/jerichosequitin","name":"Jericho Sequitin"},"license":"MIT","_id":"@jerichosequitin/metabase-mcp@1.1.4","maintainers":[{"name":"jerichosequitin","email":"work@jerichosequitin.com"}],"homepage":"https://github.com/jerichosequitin/metabase-mcp#readme","bugs":{"url":"https://github.com/jerichosequitin/metabase-mcp/issues"},"bin":{"metabase-mcp":"build/src/index.js"},"dist":{"shasum":"a5a66c24b17eabab763ebf9ad674926d53f0343e","tarball":"https://registry.npmjs.org/@jerichosequitin/metabase-mcp/-/metabase-mcp-1.1.4.tgz","fileCount":135,"integrity":"sha512-U+DZ6j4FEUWEeYhnWVPkUk/jwH1ozNfyc+mxkuZYFvMDTgyZbUh0fVeOjLTwoLRNxJ1Cc5vrK8lY3JWbr5WVxg==","signatures":[{"sig":"MEUCIFAJun1gKPSzr87d+NrzxHjOftB4w5wF/KeOXC/VC/HYAiEAwjTg5fzhYzXM4vmSVlLTKkjQLkPTFpRDKQCL7Jbe7bI=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":786173},"type":"module","engines":{"node":">=18.0.0"},"gitHead":"8fcf004ac12ac3e2eb3c148488a847449e4e5617","scripts":{"dev":"tsc && node build/src/index.js","lint":"eslint src/","test":"vitest run","build":"npm run validate && tsc && npm test && node -e \"require('fs').chmodSync('build/src/index.js', '755')\"","clean":"rm -rf build node_modules/.cache","start":"node build/src/index.js","watch":"tsc --watch","format":"prettier --write \"src/**/*.ts\"","prepare":"npm run build:fast && husky","version":"node scripts/sync-version.cjs && git add README.md manifest.json Dockerfile","lint:fix":"eslint src/ --fix","test:all":"./scripts/test-all.sh","validate":"npm run type-check && npm run lint && npm run format:check","dev:watch":"npm run build && concurrently \"tsc --watch\" \"nodemon --delay 2 build/src/index.js\"","inspector":"npx @modelcontextprotocol/inspector build/src/index.js","build:fast":"tsc && node -e \"require('fs').chmodSync('build/src/index.js', '755')\"","mcpb:build":"npm run build && node scripts/build-mcpb.cjs","test:watch":"vitest","type-check":"tsc --noEmit","build:clean":"rm -rf build && npm run build","format:check":"prettier --check \"src/**/*.ts\"","mcpb:validate":"echo 'MCPB validation - checking manifest structure' && node -e \"const fs = require('fs'); const manifest = JSON.parse(fs.readFileSync('manifest.json', 'utf8')); console.log('Manifest valid:', manifest.name, manifest.version);\"","test:coverage":"vitest run --coverage"},"_npmUser":{"name":"jerichosequitin","email":"work@jerichosequitin.com"},"repository":{"url":"git+https://github.com/jerichosequitin/metabase-mcp.git","type":"git"},"_npmVersion":"10.8.2","description":"A high-performance MCP server for Metabase analytics integration with response optimization and robust error handling","directories":{},"_nodeVersion":"20.19.6","dependencies":{"zod":"^3.25.0","xlsx":"https://cdn.sheetjs.com/xlsx-0.20.3/xlsx-0.20.3.tgz","dotenv":"^16.3.1","@types/xlsx":"^0.0.35","@modelcontextprotocol/sdk":"^1.23.0"},"_hasShrinkwrap":false,"devDependencies":{"husky":"^9.0.11","eslint":"^9.39.2","vitest":"^4.0.15","nodemon":"^3.0.2","prettier":"^3.2.5","typescript":"^5.3.3","@types/node":"^20.17.22","concurrently":"^8.2.2","typescript-eslint":"^8.49.0","@vitest/coverage-v8":"^4.0.15"},"_npmOperationalInternal":{"tmp":"tmp/metabase-mcp_1.1.4_1765734759905_0.44100718845437226","host":"s3://npm-registry-packages-npm-production"}},"1.1.5":{"name":"@jerichosequitin/metabase-mcp","version":"1.1.5","keywords":["metabase","mcp","model-context-protocol","ai","claude","analytics","business-intelligence","sql"],"author":{"url":"https://github.com/jerichosequitin","name":"Jericho Sequitin"},"license":"MIT","_id":"@jerichosequitin/metabase-mcp@1.1.5","maintainers":[{"name":"jerichosequitin","email":"work@jerichosequitin.com"}],"homepage":"https://github.com/jerichosequitin/metabase-mcp#readme","bugs":{"url":"https://github.com/jerichosequitin/metabase-mcp/issues"},"bin":{"metabase-mcp":"build/src/index.js"},"dist":{"shasum":"c18ceda8f0fc6f00f43c51f9bb55aeeb747a8673","tarball":"https://registry.npmjs.org/@jerichosequitin/metabase-mcp/-/metabase-mcp-1.1.5.tgz","fileCount":135,"integrity":"sha512-ZebU7amjoeYwLfnKT/lfpprtgh5V1fSexrQF63g1k/GRpXwraWv5SdcX0fgldhtcN3GtkdjnhENL0s7vebKA8A==","signatures":[{"sig":"MEUCIAf9IkkEfPE+dYDEojTYi8Ym0M+9BF9IAUU5BRfj3hxGAiEA+lk/mSFf/4EMNiUA1Aq+2gLY1p4uTMFLH76DudqASig=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":789138},"type":"module","engines":{"node":">=18.0.0"},"gitHead":"1b1b493d24e9d61056329db7faf8eb42ad4bf482","scripts":{"dev":"tsc && node build/src/index.js","lint":"eslint src/","test":"vitest run","build":"npm run validate && tsc && npm test && node -e \"require('fs').chmodSync('build/src/index.js', '755')\"","clean":"rm -rf build node_modules/.cache","start":"node build/src/index.js","watch":"tsc --watch","format":"prettier --write \"src/**/*.ts\"","prepare":"npm run build:fast && husky","version":"node scripts/sync-version.cjs && git add manifest.json Dockerfile src/server.ts","lint:fix":"eslint src/ --fix","test:all":"./scripts/test-all.sh","validate":"npm run type-check && npm run lint && npm run format:check","dev:watch":"npm run build && concurrently \"tsc --watch\" \"nodemon --delay 2 build/src/index.js\"","inspector":"npx @modelcontextprotocol/inspector build/src/index.js","build:fast":"tsc && node -e \"require('fs').chmodSync('build/src/index.js', '755')\"","mcpb:build":"npm run build && node scripts/build-mcpb.cjs","test:watch":"vitest","type-check":"tsc --noEmit","build:clean":"rm -rf build && npm run build","format:check":"prettier --check \"src/**/*.ts\"","mcpb:validate":"echo 'MCPB validation - checking manifest structure' && node -e \"const fs = require('fs'); const manifest = JSON.parse(fs.readFileSync('manifest.json', 'utf8')); console.log('Manifest valid:', manifest.name, manifest.version);\"","test:coverage":"vitest run --coverage"},"_npmUser":{"name":"jerichosequitin","email":"work@jerichosequitin.com"},"repository":{"url":"git+https://github.com/jerichosequitin/metabase-mcp.git","type":"git"},"_npmVersion":"10.8.2","description":"A high-performance MCP server for Metabase analytics integration with response optimization and robust error handling","directories":{},"_nodeVersion":"20.20.0","dependencies":{"zod":"^3.25.0","xlsx":"https://cdn.sheetjs.com/xlsx-0.20.3/xlsx-0.20.3.tgz","dotenv":"^16.3.1","@types/xlsx":"^0.0.35","@modelcontextprotocol/sdk":"^1.23.0"},"_hasShrinkwrap":false,"devDependencies":{"husky":"^9.0.11","eslint":"^9.39.2","vitest":"^4.0.15","nodemon":"^3.0.2","prettier":"^3.2.5","typescript":"^5.3.3","@types/node":"^20.17.22","concurrently":"^8.2.2","typescript-eslint":"^8.49.0","@vitest/coverage-v8":"^4.0.15"},"_npmOperationalInternal":{"tmp":"tmp/metabase-mcp_1.1.5_1769927691431_0.4440392001302269","host":"s3://npm-registry-packages-npm-production"}},"1.1.6":{"name":"@jerichosequitin/metabase-mcp","version":"1.1.6","keywords":["metabase","mcp","model-context-protocol","ai","claude","analytics","business-intelligence","sql"],"author":{"url":"https://github.com/jerichosequitin","name":"Jericho Sequitin"},"license":"MIT","_id":"@jerichosequitin/metabase-mcp@1.1.6","maintainers":[{"name":"jerichosequitin","email":"work@jerichosequitin.com"}],"homepage":"https://github.com/jerichosequitin/metabase-mcp#readme","bugs":{"url":"https://github.com/jerichosequitin/metabase-mcp/issues"},"bin":{"metabase-mcp":"build/src/index.js"},"dist":{"shasum":"3204be05fd4d8bda71b842a7f97d7b7c9d57c940","tarball":"https://registry.npmjs.org/@jerichosequitin/metabase-mcp/-/metabase-mcp-1.1.6.tgz","fileCount":138,"integrity":"sha512-sU8uH5Rlqp6mIUbW6gjRTjXfNVV/HK6Ik1NLvDThtiTo9cMzKOPTi9H7cIEoUznD5Dq4CjY62YRszf8zbRkPBg==","signatures":[{"sig":"MEQCIGp9WKw+HsqhziU6vNozF6HwFNlu8FTwhcJKycftsTZeAiBsQact5OwHx2dEplChQ8laKimanH+tQ9+KiN5+QrZvmw==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":802167},"type":"module","engines":{"node":">=18.0.0"},"gitHead":"334091b8bb2c9ccd41ed4f691ba9a0e2953d80be","scripts":{"dev":"tsc && node build/src/index.js","lint":"eslint src/","test":"vitest run","build":"npm run validate && tsc && npm test && node -e \"require('fs').chmodSync('build/src/index.js', '755')\"","clean":"rm -rf build node_modules/.cache","start":"node build/src/index.js","watch":"tsc --watch","format":"prettier --write \"src/**/*.ts\"","prepare":"npm run build:fast && husky","version":"node scripts/sync-version.cjs && git add manifest.json Dockerfile src/server.ts","lint:fix":"eslint src/ --fix","test:all":"./scripts/test-all.sh","validate":"npm run type-check && npm run lint && npm run format:check","dev:watch":"npm run build && concurrently \"tsc --watch\" \"nodemon --delay 2 build/src/index.js\"","inspector":"npx @modelcontextprotocol/inspector build/src/index.js","build:fast":"tsc && node -e \"require('fs').chmodSync('build/src/index.js', '755')\"","mcpb:build":"npm run build && node scripts/build-mcpb.cjs","test:watch":"vitest","type-check":"tsc --noEmit","build:clean":"rm -rf build && npm run build","format:check":"prettier --check \"src/**/*.ts\"","mcpb:validate":"echo 'MCPB validation - checking manifest structure' && node -e \"const fs = require('fs'); const manifest = JSON.parse(fs.readFileSync('manifest.json', 'utf8')); console.log('Manifest valid:', manifest.name, manifest.version);\"","test:coverage":"vitest run --coverage"},"_npmUser":{"name":"jerichosequitin","email":"work@jerichosequitin.com"},"repository":{"url":"git+https://github.com/jerichosequitin/metabase-mcp.git","type":"git"},"_npmVersion":"10.8.2","description":"A high-performance MCP server for Metabase analytics integration with response optimization and robust error handling","directories":{},"_nodeVersion":"20.20.2","dependencies":{"zod":"^3.25.0","xlsx":"https://cdn.sheetjs.com/xlsx-0.20.3/xlsx-0.20.3.tgz","dotenv":"^16.3.1","@types/xlsx":"^0.0.35","@modelcontextprotocol/sdk":"^1.23.0"},"_hasShrinkwrap":false,"devDependencies":{"husky":"^9.0.11","eslint":"^9.39.2","vitest":"^4.0.15","nodemon":"^3.0.2","prettier":"^3.2.5","typescript":"^5.3.3","@types/node":"^20.17.22","concurrently":"^8.2.2","typescript-eslint":"^8.49.0","@vitest/coverage-v8":"^4.0.15"},"_npmOperationalInternal":{"tmp":"tmp/metabase-mcp_1.1.6_1780544648730_0.1912035978602058","host":"s3://npm-registry-packages-npm-production"}},"1.1.7":{"name":"@jerichosequitin/metabase-mcp","version":"1.1.7","description":"A high-performance MCP server for Metabase analytics integration with response optimization and robust error handling","type":"module","author":{"name":"Jericho Sequitin","url":"https://github.com/jerichosequitin"},"bin":{"metabase-mcp":"build/src/index.js"},"scripts":{"build":"npm run validate && tsc && npm test && node -e \"require('fs').chmodSync('build/src/index.js', '755')\"","build:clean":"rm -rf build && npm run build","build:fast":"tsc && node -e \"require('fs').chmodSync('build/src/index.js', '755')\"","prepare":"npm run build:fast && husky","watch":"tsc --watch","inspector":"npx @modelcontextprotocol/inspector build/src/index.js","start":"node build/src/index.js","dev":"tsc && node build/src/index.js","dev:watch":"npm run build && concurrently \"tsc --watch\" \"nodemon --delay 2 build/src/index.js\"","lint":"eslint src/","lint:fix":"eslint src/ --fix","format":"prettier --write \"src/**/*.ts\"","format:check":"prettier --check \"src/**/*.ts\"","type-check":"tsc --noEmit","validate":"npm run type-check && npm run lint && npm run format:check","test":"vitest run","test:watch":"vitest","test:coverage":"vitest run --coverage","test:all":"./scripts/test-all.sh","clean":"rm -rf build node_modules/.cache","version":"node scripts/sync-version.cjs && git add manifest.json Dockerfile src/server.ts","mcpb:build":"npm run build && node scripts/build-mcpb.cjs","mcpb:validate":"echo 'MCPB validation - checking manifest structure' && node -e \"const fs = require('fs'); const manifest = JSON.parse(fs.readFileSync('manifest.json', 'utf8')); console.log('Manifest valid:', manifest.name, manifest.version);\""},"dependencies":{"@modelcontextprotocol/sdk":"^1.23.0","@types/xlsx":"^0.0.35","dotenv":"^16.3.1","xlsx":"https://cdn.sheetjs.com/xlsx-0.20.3/xlsx-0.20.3.tgz","zod":"^3.25.0"},"devDependencies":{"@types/node":"^20.17.22","@vitest/coverage-v8":"^4.0.15","concurrently":"^8.2.2","eslint":"^9.39.2","husky":"^9.0.11","nodemon":"^3.0.2","prettier":"^3.2.5","typescript":"^5.3.3","typescript-eslint":"^8.49.0","vitest":"^4.0.15"},"keywords":["metabase","mcp","model-context-protocol","ai","claude","analytics","business-intelligence","sql"],"repository":{"type":"git","url":"git+https://github.com/jerichosequitin/metabase-mcp.git"},"homepage":"https://github.com/jerichosequitin/metabase-mcp#readme","bugs":{"url":"https://github.com/jerichosequitin/metabase-mcp/issues"},"license":"MIT","engines":{"node":">=18.0.0"},"_id":"@jerichosequitin/metabase-mcp@1.1.7","gitHead":"3b92af2ed94911280bef7bd25a3d93b224d3b703","_nodeVersion":"20.20.2","_npmVersion":"10.8.2","dist":{"integrity":"sha512-sj2CtSq2aYlGkMekU59ODPfHkRYtNdn36QCinv3uaDo7AwVkRHvBGW0YUE6mB2Flc83SXcAmbEag8VZhwTlBhw==","shasum":"5bf650bf98f37ad1635a0fab6c05e78c3f18e45d","tarball":"https://registry.npmjs.org/@jerichosequitin/metabase-mcp/-/metabase-mcp-1.1.7.tgz","fileCount":141,"unpackedSize":810558,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIFbq2cMb5B5wclV8Y5oMpCJToZz91Ayj8+AJoGMmQ69dAiEA2zg6U2Dtrt06SUtymjNcH7IpivqhGB1UkuJFIqZMJqg="}]},"_npmUser":{"name":"jerichosequitin","email":"work@jerichosequitin.com"},"directories":{},"maintainers":[{"name":"jerichosequitin","email":"work@jerichosequitin.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/metabase-mcp_1.1.7_1784733859584_0.6292703329942759"},"_hasShrinkwrap":false}},"time":{"created":"2025-12-13T17:57:44.898Z","modified":"2026-07-22T15:24:19.948Z","1.1.3":"2025-12-13T17:57:45.119Z","1.1.4":"2025-12-14T17:52:40.093Z","1.1.5":"2026-02-01T06:34:51.572Z","1.1.6":"2026-06-04T03:44:09.101Z","1.1.7":"2026-07-22T15:24:19.764Z"},"bugs":{"url":"https://github.com/jerichosequitin/metabase-mcp/issues"},"author":{"name":"Jericho Sequitin","url":"https://github.com/jerichosequitin"},"license":"MIT","homepage":"https://github.com/jerichosequitin/metabase-mcp#readme","keywords":["metabase","mcp","model-context-protocol","ai","claude","analytics","business-intelligence","sql"],"repository":{"type":"git","url":"git+https://github.com/jerichosequitin/metabase-mcp.git"},"description":"A high-performance MCP server for Metabase analytics integration with response optimization and robust error handling","maintainers":[{"name":"jerichosequitin","email":"work@jerichosequitin.com"}],"readme":"# Metabase MCP\n\n[![Ask DeepWiki](https://deepwiki.com/badge.svg)](https://deepwiki.com/jerichosequitin/metabase-mcp)\n[![npm version](https://img.shields.io/npm/v/@jerichosequitin/metabase-mcp)](https://www.npmjs.com/package/@jerichosequitin/metabase-mcp)\n[![License: MIT](https://img.shields.io/badge/License-MIT-blue.svg)](https://opensource.org/licenses/MIT)\n[![Node.js](https://img.shields.io/badge/Node.js-%3E%3D18.0.0-brightgreen?logo=node.js&logoColor=white)](https://nodejs.org/)\n[![TypeScript](https://img.shields.io/badge/TypeScript-5.3-blue?logo=typescript&logoColor=white)](https://www.typescriptlang.org/)\n[![GitHub stars](https://img.shields.io/github/stars/jerichosequitin/metabase-mcp)](https://github.com/jerichosequitin/metabase-mcp/stargazers)\n\n[![Buy Me A Coffee](https://img.shields.io/badge/Buy%20Me%20A%20Coffee-FFDD00?logo=buymeacoffee&logoColor=black)](https://buymeacoffee.com/jerichosequitin)\n\nA high-performance Model Context Protocol server for AI integration with Metabase analytics platforms. Features response optimization, robust error handling, and comprehensive data access tools.\n\n<a href=\"https://glama.ai/mcp/servers/@jerichosequitin/Metabase\">\n  <img width=\"380\" height=\"200\" src=\"https://glama.ai/mcp/servers/@jerichosequitin/Metabase/badge\" />\n</a>\n\n## Key Features\n\n- **Response Optimization**: Up to 90% token reduction for efficient AI context usage\n- **Robust Error Handling**: Comprehensive error handling with structured, actionable responses\n- **Smart Caching**: Multi-layer caching with configurable TTL for improved performance\n- **Unified Commands**: `list`, `retrieve`, `search`, `execute`, and `export` tools\n- **Dual Authentication**: API key or email/password authentication\n- **Large Data Export**: Export up to 1M rows in CSV, JSON, and XLSX formats\n- **Read-Only Mode**: Enabled by default to restrict execute to SELECT queries only\n\n## Installation\n\n### Option 1: Claude Desktop\n\nInstall directly from the [Claude Desktop Directory](https://claude.ai/directory/connectors/ant.dir.gh.jerichosequitin.metabase), or:\n\n1. Download `metabase-mcp.mcpb` from [Releases](https://github.com/jerichosequitin/metabase-mcp/releases)\n2. Open the `.mcpb` file with Claude Desktop to install\n3. Configure your Metabase credentials in Claude Desktop's extension settings\n\n### Option 2: Manual Configuration\n\nAdd the following to your MCP client configuration:\n\n```jsonc\n{\n  \"mcpServers\": {\n    \"metabase-mcp\": {\n      \"command\": \"npx\",\n      \"args\": [\"-y\", \"@jerichosequitin/metabase-mcp\"],\n      \"env\": {\n        // Required\n        \"METABASE_URL\": \"https://your-metabase-instance.com\",\n\n        // Authentication (choose one)\n        \"METABASE_API_KEY\": \"your_api_key_here\",       // API key (recommended)\n        \"METABASE_USER_EMAIL\": \"\",                     // OR email/password\n        \"METABASE_PASSWORD\": \"\",\n\n        // Optional (defaults shown)\n        \"EXPORT_DIRECTORY\": \"~/Downloads/Metabase\",    // Export location\n        \"METABASE_PROXY_AUTHORIZATION\": \"\",            // Optional Proxy-Authorization value for IAP, e.g. \"Bearer <token>\"\n        \"METABASE_READ_ONLY_MODE\": \"true\",             // Restrict to SELECT queries\n        \"LOG_LEVEL\": \"info\",                           // debug, info, warn, error, fatal (debug enables pretty JSON)\n        \"CACHE_TTL_MS\": \"600000\",                      // 10 minutes\n        \"REQUEST_TIMEOUT_MS\": \"600000\"                 // 10 minutes\n      }\n    }\n  }\n}\n```\n\n### Option 3: Docker\n\nFor containerized deployments without installing Node.js. Add to your MCP client configuration:\n\n```jsonc\n{\n  \"mcpServers\": {\n    \"metabase-mcp\": {\n      \"command\": \"docker\",\n      \"args\": [\n        \"run\", \"-i\", \"--rm\", \"--init\",\n        \"-e\", \"METABASE_URL=https://your-metabase-instance.com\",\n        \"-e\", \"METABASE_API_KEY=your_api_key\",\n        // Optional: mount volume for exports\n        // \"-v\", \"~/Downloads/Metabase:/home/node/exports\",\n        \"ghcr.io/jerichosequitin/metabase-mcp:latest\"\n      ]\n    }\n  }\n}\n```\n\nOr build locally: `docker build -t metabase-mcp .` and use `metabase-mcp` as the image name.\n\n**Required flags:** `-i` (interactive, for MCP stdio), `--rm` (cleanup), `--init` (signal handling)\n\n**Environment variables:** Pass via `-e` flags. See [Manual Configuration](#option-2-manual-configuration) for all options. Docker defaults: `LOG_LEVEL=info`, `METABASE_READ_ONLY_MODE=true`, `EXPORT_DIRECTORY=/home/node/exports`.\n\n## Available Tools\n\n### `list`\nFetch all records for a resource type with optimized responses returning only essential fields.\n- **Models**: `cards`, `dashboards`, `tables`, `databases`, `collections`\n- **Pagination**: `offset`/`limit` parameters for large datasets\n\n### `retrieve`\nGet detailed information for specific items by ID with concurrent processing.\n- **Models**: `card`, `dashboard`, `table`, `database`, `collection`, `field`\n- **Batch Support**: Up to 50 IDs per request\n- **Pagination**: `table_offset`/`table_limit` for databases with many tables\n\n### `search`\nSearch across all Metabase items using the native search API.\n- **Filtering**: By model type, database ID, or content\n- **Options**: Search native SQL queries, include dashboard questions\n\n### `execute`\nExecute SQL queries or run saved cards with configurable row limits (default: 100, max: 500).\n- **SQL Mode**: Custom queries with `database_id` and `query`\n- **Card Mode**: Saved cards with `card_id` and optional `card_parameters` for filtering\n- **Security**: Respects Read-Only Mode (blocks INSERT, UPDATE, DELETE, DROP, etc.)\n\n### `export`\nExport large datasets up to 1M rows to the configured export directory.\n- **Formats**: CSV, JSON, XLSX\n- **SQL Mode**: Export custom query results\n- **Card Mode**: Export saved card results with optional filtering\n- **Note**: When using hosted remote deployments (e.g., Glama), exported files are saved inside the container and are inaccessible. Use `execute` for query results directly, or run locally via npx/Docker for full export functionality.\n\n### `clear_cache`\nClear internal cache with granular control.\n- **Targets**: Individual model caches, list caches, or bulk operations (`all`, `all-lists`, `all-individual`)\n\n## For Developers\n\n### Prerequisites\n- Node.js 18.0.0 or higher\n- Active Metabase instance\n\n### Setup\n\n```bash\ngit clone https://github.com/jerichosequitin/metabase-mcp.git\ncd metabase-mcp\nnpm install\nnpm run build\n```\n\nThen configure your MCP client to use the local build:\n\n```jsonc\n{\n  \"mcpServers\": {\n    \"metabase-mcp\": {\n      \"command\": \"node\",\n      \"args\": [\"/path/to/metabase-mcp/build/src/index.js\"],\n      \"env\": { /* see Manual Configuration for options */ }\n    }\n  }\n}\n```\n\n### Debugging\n\nUse the [MCP Inspector](https://github.com/modelcontextprotocol/inspector) for development:\n\n```bash\nnpm run inspector\n```\n\n### Testing\n\n```bash\nnpm test                 # Run tests\nnpm run test:coverage    # Coverage report\n```\n\n### Building MCPB Package\n\n```bash\nnpm run mcpb:build\n```\n\nCreates `metabase-mcp-{version}.mcpb` ready for GitHub Releases.\n\n## Security\n\n**Read-Only Mode** is enabled by default (`METABASE_READ_ONLY_MODE=true`), restricting the `execute` tool to SELECT queries only. Write operations (INSERT, UPDATE, DELETE, DROP, etc.) are blocked. Set to `false` to allow write operations.\n\n**Authentication**: API key authentication is recommended over email/password for production use.\n\n**Proxy Authentication**: Set `METABASE_PROXY_AUTHORIZATION` when Metabase is behind a proxy that requires a `Proxy-Authorization` header, such as Google IAP. The value is passed through exactly as provided, for example `Bearer <token>`.\n\n## License\n\nThis project is licensed under the MIT License.\n","readmeFilename":"README.md"}