PostgreSQL Database integration: operations for AI agents
PostgreSQL Database connects to Type.com as an integration. This page lists the 4 operations documented for Claude and Codex in Type.com: 4 read.
About PostgreSQL Database
Query customer-connected external PostgreSQL databases through Type's read-only database tools.
Categories: Analytics & Data
How to connect PostgreSQL Database to Type.com
- Connect
- Database host, port, database name, username and password; configure SSL and optional SSH tunnel
- Access
- Organization connection: one shared account for the workspace.
To add the connection, follow the steps in Space connections.
Documented operations
4 operations. Your connection's permissions determine which operations are available.
- Read
get database table schema
Get a bounded page of complete column metadata for a selected PostgreSQL table. Follow nextCursor until all required columns have been inspected, then use postgresql_query.
- Read
list databases
List customer-connected external PostgreSQL databases connected to the current space and available to this agent. These are not Type workspace data and not an app's own database. Returns bounded database and schema summaries without table or column details. Call this first, then use search_database_schema and get_database_table_schema before writing SQL.
- Read
postgresql query
Execute a read-only SQL SELECT query against a customer-connected external PostgreSQL database. Do not use this for an app's own database. Call list_databases, search relevant identifiers with search_database_schema, and inspect selected tables with get_database_table_schema before writing SQL. Do not query PostgreSQL system catalogs for schema discovery. The statement must begin with SELECT; WITH/CTE queries are not accepted. Always use LIMIT (10-100 rows) unless aggregating. Response includes column metadata with a 'category' field (numeric, temporal, categorical) to guide visualization. After getting results, render them using a json-render code block. Format: ```json-render { "root": "chart-1", "elements": { "chart-1": { "key": "chart-1", "type": "BarChart", "props": { "title": "Title", "data": [rows], "xAxisKey": "col", "series": [{"dataKey": "col", "name": "Label"}] } } } } ```. Types: BarChart (categories), LineChart (trends), PieChart ({name,value}), AreaChart (cumulative), DataTable (columns:[{key,header}] + data), MetricCard ({title,value}). Pick by column category: temporal → LineChart/AreaChart, categorical → BarChart, single aggregate → MetricCard.
- Read
search database schema
Search PostgreSQL schema, table, and column identifiers in one connected database. The cache refreshes on access after 24 hours. Set forceRefresh to true if tables or columns may have changed. Use domain terms from the request and retry with narrower identifier-like terms when needed. Inspect likely matches with get_database_table_schema before writing SQL.
No operations match.
Not supported
- INSERT, UPDATE, DELETE, DDL and other database mutations
Get started
- Open Space settings → Connections and search for PostgreSQL Database.
- Connect your account and add the connection to the Space.
- Ask for what you need in any thread in that Space.
See How connections work for access and permissions, or browse all integrations.
Reference date: October 28, 2026.