Waterboards MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MCP_TRANSPORT | No | Transport mode for the MCP server, e.g. streamable-http to run in HTTP mode. | |
| DATABRICKS_HOST | No | Databricks workspace host URL used with token authentication. | |
| DATABRICKS_TOKEN | No | Databricks personal access token used with DATABRICKS_HOST authentication. | |
| DATABRICKS_CONFIG_PROFILE | No | Databricks CLI profile name used for unified authentication. | |
| DATABRICKS_SQL_WAREHOUSE_ID | Yes | The Databricks SQL warehouse ID used to query the Gold views. |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
California drinking water open data (State Water Board SDWIS, SAFER risk assessment, source-water chemistry, school lead sampling) served from curated Databricks Gold views. Find water systems, source chemistry, and school lead results by ZIP code or water system ID. Report only what the tools return, always cite the result's source_url and its data_as_of/last_observed date, and say so when no data is found. Values are not a health determination.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
| logging | {} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| waterboards_list_datasetsA | List the water datasets (Gold views) available through this server. Source: Unity Catalog information_schema for the configured Gold schema. Refresh cadence: reflects the current catalog; underlying data refresh varies by dataset (see each view's comment). Returns a pagination envelope; each result has |
| waterboards_find_water_systems_near_zipA | Find drinking water systems serving the area near a ZIP code. Source: Gold view v_water_systems_near_zip (California State Water
Board SDWIS inventory + SAFER risk assessment). Refreshed when the
pipeline reloads the open data; each result has Set Each result has pws_id, system_name, county, city, federal_type,
total_population, distance_km, safer_status, is_failing,
violation flags/analytes, risk levels, and |
| waterboards_get_water_systemA | Get the profile and compliance/risk summary of one water system. Source: Gold view v_water_systems (California State Water Board SDWIS
inventory + SAFER risk assessment). Refreshed when the pipeline reloads
the open data; the result carries The single result has system name, county, city, type, owner, source
type, population, service connections, last sanitary survey,
safer_status, is_failing, economic_status (DAC/SDAC), violation
flags with analytes (primary/secondary MCL, E. coli, treatment
technique, monitoring), risk levels by category, and |
| waterboards_get_source_chemistry_near_zipA | Get latest source-water chemistry for wells near a ZIP code. Source: Gold view v_source_chemistry_near_zip (DDW/GAMA drinking water
source chemistry, 2020 to present). Refreshed when the pipeline reloads
the open data; each result has
Each result is the latest sample for one well and chemical: pws_id,
system_name, well_id, chemical_name, result_numeric, units,
reporting_limit, is_non_detect, |
| waterboards_get_system_source_chemistryA | Get latest source-water chemistry for one water system's wells. Source: Gold view v_source_chemistry_latest (DDW/GAMA drinking water
source chemistry, 2020 to present). Refreshed when the pipeline reloads
the open data; each result has
Each result is the latest sample for one well and chemical: pws_id,
system_name, well_id, chemical_name, result_numeric, units,
reporting_limit, is_non_detect, |
| waterboards_get_school_lead_near_zipA | Get lead-in-drinking-water results at K-12 schools near a ZIP code. Source: Gold view v_school_lead_near_zip (California State Water Board
school lead sampling, 2020 onward; the data on file stops at the
newest
Each result has school_name, district, school_zip, sample_location,
result_numeric and units (UG/L), reporting_limit, is_non_detect
(result_numeric is null when true), action_level_exceeded,
follow_up_action, |
| waterboards_get_tap_water_for_zipA | Get the latest tap-water test results for a California ZIP code. Source: Gold view v_tap_water_for_zip (DDW SDWIS sample results, 2023 to
present, joined to water-system service-area boundaries). Refreshed when
the pipeline reloads the open data; each result has
Each result: zip, pct_of_zip_covered, pws_id, system_name, total_population, water_stage, analyte_name, result_numeric, units, is_non_detect, reporting_limit, mcl, exceeds_mcl, any_exceeds_mcl, max_result_numeric, sample_count, last_observed, sampling_point, method, source_url. When is_non_detect is true, result_numeric is null and the analyte was below reporting_limit. These are system-level samples, not results for an individual address or home. A single sample above the MCL is not a violation by itself (many limits apply to running averages), and this is not a health determination. Units vary by analyte; never compare across units. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
| drinking_water_question | Ask what drinking water information exists near a ZIP code. |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| about | Data provenance, citations, and caveats for this server. |
| security_posture | Read-only summary of the active security controls and risk counters. |
TDQS
Scored across 7 tools
Each tool maps to a distinct dataset/query axis: catalog listing, systems near a ZIP, single-system profile, source chemistry by ZIP vs by system, school lead, and tap water. The only near-pair is get_source_chemistry_near_zip vs get_system_source_chemistry, which descriptions do separate by lookup key (ZIP vs pws_id). Source vs tap water vs school lead are clearly delineated in the descriptions.
All names use the same waterboards_ prefix and snake_case verb_noun form, which is highly predictable. Minor inconsistency: 'get_source_chemistry_near_zip' places the qualifier at the end while its sibling is 'get_system_source_chemistry', so the pair reads less symmetrically than the rest.
Seven tools is well-scoped for a read-only public-data server; each tool corresponds to one backing Gold view or catalog operation. No redundant or padding tools are present.
The surface covers discovery, system lookup, source chemistry (two access paths), school lead, and tap water, which is a strong read-only lifecycle for the domain. Gaps are minor: no name/county search for a water system, no way to resolve a ZIP's serving systems beyond distance-based proximity, and no violation-detail listing beyond flags in the system profile.