DeployGet started

Postgres Search API

A generic search API for querying Postgres tables using dynamic filters.

Version 1.0.01 endpoints
Postgres Search API logo

Endpoints

GET/searchsearch

Perform a filtered query against any table in the database.

Parameters

NameInRequiredDescription
tablequeryYesThe name of the table to search.
fieldsqueryNoComma-separated list of fields to return (e.g., `id,name,email`).
wherequeryNoJSON object representing WHERE conditions (e.g., `{"status":"active"}`).
order_byqueryNoColumn name to order by.
orderqueryNoOrder direction (`asc` or `desc`).
limitqueryNoMaximum number of results to return.
offsetqueryNoNumber of records to skip (for pagination).

Responses

StatusDescription
200A list of records matching the query
400Invalid input (e.g., missing `table`, bad `where` JSON)

Need help deploying this MCP server?

Product Screenshot