water_dataframe_query

MCP tool from Usgs Water MCP Server by cyanheads

Run a read-only SQL SELECT against the time-series and site tables staged by watergetseries and waterfindsites.

How to use it

water_dataframe_query is exposed by the Usgs Water MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the water_dataframe_query tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

Install Usgs Water MCP Server

$docker run --rm -p 3010:3010 usgs-water-mcp-server

FULL USGS WATER MCP SERVER LISTING

Other tools in Usgs Water MCP Server (6)

water_dataframe_describe

List tables and columns staged on a DataCanvas by watergetseries or waterfindsites.

water_find_sites

Find USGS monitoring sites by bounding box, state, county, or HUC watershed. Filter by site type and parameter availability. Large match sets spill to DataCanvas.

water_get_conditions

Get current hydrologic conditions ranked against the full period-of-record percentile statistics.

water_get_readings

Get the latest instantaneous values (~15 min real-time) for up to 100 USGS sites.

water_get_series

Get a time series of daily or instantaneous values for a site over a date range. Large ranges spill to DataCanvas.

water_list_parameters

Static lookup of well-known USGS parameter codes with names, units, and domain. No network call.