How to perform SELECT queries in PostgreSQL MCP Connectors

PPN Hub — public APIs over MCP A

One MCP endpoint over 69 public PPN APIs: search_apis to discover, execute_api to call. Free tier.

Search Open Data

32

earthquake-mcp-server A

Search USGS and EMSC seismic data — real-time feeds, event queries, and earthquake counts.

Government Data Open Data

421

LTS MCP Server A

A Model Context Protocol server that provides Philippine License to Sell (LTS) verification data to LLMs. Built on Cloudflare Workers with Supabase. Public, read-only, no authentication required. Data sourced from the Department of Human Settlements and Urban Development (DHSUD) License to Sell registry and cross-referenced with published real estate projects on REN.PH.

Government Data Real Estate Open Data

122

psgc-mcp A

MCP server for the Philippine Standard Geographic Code (PSGC) API. Gives AI agents structured access to the full PH geographic hierarchy - regions, provinces, cities, municipalities, and barangays.

Government Data Location Services Open Data

72

Signal Nodus SEC Filings A

Sentence-level YoY diffs of 10-K/10-Q sections, pinned to accession numbers. Pay per call x402.

Finance Open Data

71

FedSignal — Federal Contract Exposure, USAspending to SEC Issuer Resolution A

Federal government contracts and USAspending procurement exposure for SEC-listed companies.

Government Data Finance Open Data

81

Federal Grants — find funding you are actually eligible for A

Find US federal grants your organization is actually eligible to apply for. Free, no API key.

Government Data Open Data Research & Data

311

Islam West Africa Collection (IWAC)A

Read-only access to the Islam West Africa Collection via Hugging Face datasets.

Art & Culture Open Data Research & Data

3421

TrendFlow A

Google Trends data: interest over time, by region, related queries, and trending now.

Search Research & Data Open Data

811

US Economic, SEC EDGAR & On-Chain Data (x402)A

21 paid tools: US macro data, SEC EDGAR filings, on-chain EVM reads. Settled in USDC on Base.

Finance Blockchain Open Data

211

signal-bureau A

Calibrated probability reads on world events - source-traced, publicly graded, free to query.

Open Data Research & Data

211

Professor Sausages — Web & Documents A

Read pages & files to text, news, weather, market holidays and timezones via x402.

Web Scraping Weather Services Open Data

121

DaedalMap Distributed Manufacturing Locations A

Open manufacturing and maker facility locations for country and facility-type queries.

Location Services Open Data

422

DaedalMap Geocoding and Reverse Geocoding (loc_id)A

Reverse geocode latitude/longitude to loc_id; resolve loc_ids to boundaries, centroids, hierarchy.

Location Services Open Data

2022

Servidores Federais (Transparência)A

Data on a Federal Executive public servant in the Transparency Portal from the CPF. Platform-hosted,

Government Data Search Open Data

71

Indicadores PJ (Transparência)A

Indicators for a company in the Federal Transparency Portal from the CNPJ, such as sanctions, agreem

Government Data Open Data

71

Dados Cadastrais PF (Argentina)A

Registration data for an individual in Argentina from the DNI. Platform-hosted, no credentials, pay

Government Data Open Data

71

SCR Banco Central (Resumo)A

Summary of a person's or company's credit operations in Brazil's Central Bank credit information sys

Finance Government Data Open Data

71

Australian Consumer Data Right Product Data - CDR Explorer A

CDR Explorer allows access to the Australian Consumer Data Right Product Data from Banks and Non-Bank Lenders

Finance Open Data

171

Sintegra CCC Completa A

Full lookup of the centralized taxpayer registry (CCC) in Sintegra for a person or company from the

Government Data Open Data Search

71

"How to perform SELECT queries in PostgreSQL" matching MCP connectors: