{"contractVersion":"parcelops.connector.v1","name":"postgres","displayName":"Private Property Database","description":"Read-only PostgreSQL access for customer-authorized property, transaction, lease, appraisal, and portfolio data in any market.","tags":["private-data","database","portfolio","bring-your-own"],"authentication":{"type":"connection_string","required":true},"provenance":{"sourceName":"Private Property Database"},"freshness":{"status":"not_declared"},"coverage":{"geographic":{"status":"not_declared"},"temporal":{"status":"not_declared"}},"methods":{"total":4,"items":[{"name":"query","description":"Execute a read-only SQL query in a READ ONLY transaction.","requiredParams":["sql"],"inputSchema":{"type":"object","properties":{"sql":{"type":"string"},"params":{"type":"array"}},"required":["sql"],"additionalProperties":false},"access":{"classification":"read"},"freshness":{"status":"not_declared"},"entities":{"status":"not_declared"},"pagination":{"status":"not_declared"},"output":{"schema":{"status":"not_declared"},"units":{"status":"not_declared"},"coordinateReferenceSystem":{"status":"not_declared"}},"caveats":[]},{"name":"listTables","description":"List available tables in a schema.","inputSchema":{"type":"object","properties":{"schema":{"type":"string"}},"required":[],"additionalProperties":false},"access":{"classification":"read"},"freshness":{"status":"not_declared"},"entities":{"status":"not_declared"},"pagination":{"status":"not_declared"},"output":{"schema":{"status":"not_declared"},"units":{"status":"not_declared"},"coordinateReferenceSystem":{"status":"not_declared"}},"caveats":[]},{"name":"describeTable","description":"Describe columns and keys for one table.","requiredParams":["table"],"inputSchema":{"type":"object","properties":{"table":{"type":"string"},"schema":{"type":"string"}},"required":["table"],"additionalProperties":false},"access":{"classification":"read"},"freshness":{"status":"not_declared"},"entities":{"status":"not_declared"},"pagination":{"status":"not_declared"},"output":{"schema":{"status":"not_declared"},"units":{"status":"not_declared"},"coordinateReferenceSystem":{"status":"not_declared"}},"caveats":[]},{"name":"listSchemas","description":"List non-system schemas.","inputSchema":{"type":"object","properties":{},"required":[],"additionalProperties":false},"access":{"classification":"read"},"freshness":{"status":"not_declared"},"entities":{"status":"not_declared"},"pagination":{"status":"not_declared"},"output":{"schema":{"status":"not_declared"},"units":{"status":"not_declared"},"coordinateReferenceSystem":{"status":"not_declared"}},"caveats":[]}]},"caveats":[]}