MCP Tools · find what your AI agent can connect to
358,804 tools from 21,355 MCP servers that answered our robot · tested every day · how we test
20 tools for “query postgres” in SQL Querying · best match first · at most 3 per server
analyze_sqlworks without a keyofficialAnalyze Postgres SQL/migrations for destructive operations, locking risk, correctness traps (NULL handling that silently returns wrong results), anti-patterns, and query cost. Returns a deterministic verdict (ok/warn/block) with findings. P
string_interactions_query_setworks without a keyofficialRetrieves the interactions between the query proteins. Use this method only when you specifically need to list the interactions between all proteins in your query set. - For a **single protein**, the network includes that protein and its to
query_factworks without a keyofficialExecute a registered, versioned read-only fact query against the server-pinned dataset. Provide query_id and version only: SQL is approved by the domain pack, never caller-supplied. Returns normalized rows plus a reproducible trust receipt
queryworks without a keycommunityRun a raw Overpass QL query against OpenStreetMap. Use for complex spatial queries the helper tools can't express. Example: `[out:json][timeout:25]; area["name"="Berlin"][admin_level=4]->.a; node["amenity"="library"](area.a); out body;`. Re
faostat_query_observationsworks without a keycommunityQuery a FAOSTAT domain's data cube by area(s), item(s), element(s), sources, and year range, returning values with units and data-quality flags. Resolve numeric codes or exact alphanumeric item identities with faostat_resolve_codes; element
faostat_dataframe_queryworks without a keycommunityRun a single-statement SELECT against canvas tables staged by faostat_query_observations and faostat_commodity_profile (faostat_xxxxxxxx). Use DuckDB joins, aggregates, window functions, and CTEs for rankings and time-series analysis. Item
ilostat_dataframe_queryworks without a keycommunityRun a single-statement SELECT against the df_<id> dataframes staged by ilostat_query_indicator and ilostat_compare_geographies or stored by an earlier register_as. Inspect a dataframe with ilostat_dataframe_describe first; its column schema
postgres_upgrade_precheckworks without a keyofficialChecks if a Cloud SQL for PostgreSQL instance is ready for a major version upgrade to the specified target version. The `target_database_version` MUST be provided in the request (e.g., `POSTGRES_15`). This tool helps identify potential issu
string_query_speciesworks without a keyofficialSearch for species or clades available in STRING by free-text query and return their NCBI taxonomy IDs. - Use this when the user asks which species or clades are present in STRING, or when you need the correct NCBI taxon ID to pass to other
get_answer_queriesworks without a keyofficialShow the SQL behind one answer you already received, addressed by its correlation_id. Returns only the recorded fact queries (id, version, label, SQL, parameters, result schema, dataset version) for that answer: no rows, no evidence text, n
deadbolt_catalog_queryworks without a keyofficialUse when you need to check a live Supabase project rather than migration files: returns a read-only SQL query that reads table RLS settings, grants for anon and authenticated, policies, SECURITY DEFINER functions and storage buckets (never
lancedb_queryworks without a keycommunityRAG query with context retrieval from LanceDB
ilostat_query_indicatorworks without a keycommunityFetch observations for up to 3 ILOSTAT datasets per call, filtered by reference area or area group, sex, breakdown codes (classif1, classif2), source, and period; datasets past the first 3 come back as remaining_dataset_ids for another call
query_datasetworks without a keyofficialRun read-only DuckDB SELECTs over the dataset behind the other tools, for a question none of them asks. Call describe_dataset first; it lists the 36 views, their columns, joins and recipes. Prefer a typed tool when one fits. - statements=[…
mend_query_jsonworks without a keyofficialUse when you need specific fields from a JSON document without reading all of it: $.users[0].name, $.items[*].id, $.a.b[-1], $.list[1:3], $..email (recursive). Returns each match with its exact path, type and value. Repairs the JSON first i
jhtdb_point_queryworks without a keycommunityInterpolated velocity, pressure, or velocity-gradient values at up to 10 points and a single time in a Johns Hopkins Turbulence Databases (JHTDB) reference DNS/LES dataset. Values are returned in the dataset's native simulation units (dimen
faostat_commodity_profileworks without a keycommunityAssemble a global profile for one QCL item in a single call: top-producing countries, the annual production trend, and trade flows (top exporters and importers). Supply item_code or item_query; code wins when both are supplied. A query sele
ilostat_dataframe_describeworks without a keycommunityDescribe the df_<id> dataframes staged by ilostat_query_indicator and ilostat_compare_geographies or stored by ilostat_dataframe_query register_as: the tool and parameters that produced each, the datasets it holds (label, last update, and t
string_enrichmentworks without a keyofficialThis tool retrieves functional enrichment for a set of proteins using STRING. - If queried with a single protein, the tool expands the query to include the protein’s 10 most likely interactors; enrichment is performed on this set, not the o
get_faqworks without a keyofficialCall this when a user asks a specific question about migrating a legacy IIS, classic ASP or SQL Server website, such as cost, downtime or what happens to the database. Returns published Q&As word for word, filtered by `query`. `query` is a