{"name":"io.github.kalehdoo/warehouse-mcp","slug":"kalehdoo-warehouse-mcp","title":null,"description":"Production MCP server for Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, MotherDuck.","url":"https://mcp.market/server/kalehdoo-warehouse-mcp","rating":null,"grade":"B","score":72,"certified":false,"status":"active","category":"data","tags":["data"],"presence":{"score":18,"stars":0,"forks":0,"downloads_week":52,"last_push_at":"2026-06-18T21:31:38.000Z","license":"Apache-2.0"},"uptime":null,"claimed":false,"transport":"npm","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/kalehdoo/warehouse-mcp","website":"https://github.com/kalehdoo/warehouse-mcp","version":"0.4.2","remotes":[],"packages":[{"registryType":"npm","identifier":"warehouse-mcp","version":"0.4.2","transport":{"type":"stdio"},"runtimeArguments":[{"description":"Boots the MCP server. Use 'init' for interactive setup or 'doctor' to diagnose configuration.","isRequired":true,"value":"start","type":"positional"}],"environmentVariables":[{"description":"Set to 'stdio' for desktop AI clients (Claude Desktop, Cursor). Defaults to 'http'.","default":"stdio","name":"MCP_TRANSPORT"},{"description":"Which warehouse to connect to. One of: postgres, oracle, redshift, snowflake, bigquery, duckdb. (DuckDB also handles MotherDuck via DUCKDB_PATH=md:<db>.)","isRequired":true,"format":"string","choices":["postgres","oracle","redshift","snowflake","bigquery","duckdb"],"name":"WAREHOUSE_TYPE"},{"description":"Comma-separated bearer keys with role and optional warehouse-role impersonation: 'key1:reader,key2:admin', 'key3:reader:set_role=alice'. Leave empty for stdio (OS process boundary is the trust boundary). Required for HTTP.","format":"string","isSecret":true,"name":"MCP_API_KEYS"},{"description":"DuckDB file path, ':memory:', or 'md:<database>' for MotherDuck. Required when WAREHOUSE_TYPE=duckdb.","format":"string","name":"DUCKDB_PATH"},{"description":"MotherDuck service token. Required when DUCKDB_PATH starts with 'md:'.","format":"string","isSecret":true,"name":"MOTHERDUCK_TOKEN"},{"description":"Postgres host. Required when WAREHOUSE_TYPE=postgres. (Use REDSHIFT_HOST for Redshift.)","name":"PG_HOST"},{"description":"Postgres database name.","name":"PG_DATABASE"},{"description":"Postgres user.","name":"PG_USER"},{"description":"Postgres password.","isSecret":true,"name":"PG_PASSWORD"},{"description":"Oracle user. Required when WAREHOUSE_TYPE=oracle.","name":"ORACLE_USER"},{"description":"Oracle password.","isSecret":true,"name":"ORACLE_PASSWORD"},{"description":"Oracle Easy Connect (e.g. host:1521/SERVICE), TNS descriptor, or alias.","name":"ORACLE_CONNECT_STRING"},{"description":"Snowflake account identifier (e.g. xy12345.us-east-1). Required when WAREHOUSE_TYPE=snowflake.","name":"SNOWFLAKE_ACCOUNT"},{"description":"Snowflake username.","name":"SNOWFLAKE_USER"},{"description":"Path to PKCS8 private key (.p8). Snowflake auth is key-pair only; password auth is not supported.","name":"SNOWFLAKE_PRIVATE_KEY_PATH"},{"description":"GCP project id. Required when WAREHOUSE_TYPE=bigquery.","name":"BIGQUERY_PROJECT"},{"description":"Path to BigQuery service-account JSON. Omit on GKE / Cloud Run with workload identity.","name":"GOOGLE_APPLICATION_CREDENTIALS"},{"description":"Set to 'on' to enable role-aware PII masking on result rows (emails, SSNs, phones, IPs, Luhn-validated CCs). Off by default.","default":"off","choices":["on","off"],"name":"GUARDRAIL_PII_MASK"},{"description":"Per-principal token-bucket rate limit on tool invocations. 0 = disabled. Recommend 60 for production.","default":"0","name":"MCP_RATE_LIMIT_RPM"}]}],"tools":[{"name":"column_stats","description":"Return min, max, null count, distinct count, and (for numeric columns) average for one column.","write_action":false,"price_micros":0,"input_schema":null},{"name":"count_rows","description":"Return the row count for a table. Cheap (single COUNT(*)), and answers 'how big is this?' before the agent decides whether to scan it. Especially useful on cloud warehouses where bytes scanned costs money.","write_action":false,"price_micros":0,"input_schema":null},{"name":"describe_table","description":"Return column names, types, and nullability for a table or view.","write_action":false,"price_micros":0,"input_schema":null},{"name":"find_columns","description":"Search column names across the warehouse using a SQL LIKE pattern (use % for wildcards). Returns matching (schema, table, column, type) tuples. Optionally scope to one schema. On BigQuery, schema is required because INFORMATION_SCHEMA is per-dataset.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_foreign_keys","description":"Return declared foreign-key relationships (from_schema/from_table/from_column → to_schema/to_table/to_column). Optionally scope to a schema or a single table. BigQuery only returns informational FKs that were explicitly declared.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_view_definition","description":"Return the SQL body of a view. Useful when business logic lives in views — the model can reason about a view's semantics by reading its definition.","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_schemas","description":"List all schemas (or BigQuery datasets) visible to the configured warehouse role.","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_tables","description":"List tables and views in a given schema.","write_action":false,"price_micros":0,"input_schema":null},{"name":"query","description":"Execute a single read-only SELECT against the configured warehouse. Returns columns and rows. A LIMIT (or FETCH FIRST on Oracle) is auto-applied if the SQL omits one.","write_action":true,"price_micros":0,"input_schema":null},{"name":"sample_table","description":"Return up to N sample rows from a table (capped at 100).","write_action":false,"price_micros":0,"input_schema":null},{"name":"search_value","description":"Find a literal value across the text columns of a table (exact match). Scans up to 10 text columns and returns up to 100 hits.","write_action":false,"price_micros":0,"input_schema":null},{"name":"time_series","description":"Group a table by a date/timestamp column into buckets (hour/day/week/month/quarter/year) and return a count or aggregate per bucket. Saves the agent from constructing dialect-specific date truncation. Returns rows ordered chronologically.","write_action":false,"price_micros":0,"input_schema":null},{"name":"top_values","description":"Return the top-K most frequent non-null values in a column with their counts.","write_action":false,"price_micros":0,"input_schema":null}],"scan":{"score":72,"grade":"B","scanned_at":"2026-09-27T21:47:40.535Z","report":{"scannerVersion":"0.1.9","scannedAt":"2026-09-27T21:47:40.525Z","components":{"code":{"score":25,"max":25,"notes":["46 source files scanned"]},"reliability":{"score":-1,"max":20,"notes":["no gateway calls yet and no remote to probe"]},"poisoning":{"score":-1,"max":15,"notes":["tools not inspected (local package is not executed); not counted"]},"auth":{"score":6,"max":15,"notes":["static API keys via environment variables"]},"maintenance":{"score":8,"max":15,"notes":["last push 101 days ago"]},"identity":{"score":8,"max":10,"notes":["registry namespace matches repository owner","GitHub account older than a year"]}},"findings":[],"inputs":{"packages":[{"registryType":"npm","identifier":"warehouse-mcp","version":"0.4.2","found":true,"license":"Apache-2.0","hasInstallScripts":false,"dependencyCount":18,"publishedAt":"2026-05-06T21:47:16.962Z","repositoryUrl":"git+https://github.com/kalehdoo/warehouse-mcp.git","weeklyDownloads":52}],"repo":{"found":true,"owner":"kalehdoo","repo":"warehouse-mcp","archived":false,"pushedAt":"2026-06-18T21:31:38Z","stars":0,"forks":0,"openIssues":0,"ownerType":"User","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/26747418?v=4","ownerCreatedAt":"2017-03-28T17:29:02Z","license":"Apache-2.0"},"icon":{"url":"https://avatars.githubusercontent.com/u/26747418?v=4&s=128","source":"github"},"presence":{"stars":0,"forks":0,"downloadsWeek":52,"license":"Apache-2.0","lastPushAt":"2026-06-18T21:31:38.000Z","score":18}}}},"grade_history":[],"reviews":[]}