Connect Codex to Notion and PostgreSQL

Search pages and databases by title

Query a database to retrieve pages

Retrieve a database's metadata and schema

Create a new database as a child of a page

Update a database's title, description, or properties

Retrieve a page's properties

Create a new page in a database or as a child of another page

Update a page's properties, icon, or cover

Retrieve a block

Retrieve a block's children

Append new children blocks to a parent block

Update a block's content

Delete (archive) a block

List all users in the workspace

Retrieve a user by ID

Retrieve the bot user for the current integration

Create a comment on a page or in an existing discussion thread

Retrieve a comment by its ID

List comments on a block or page

Execute a SELECT query and return results as JSON

Execute an INSERT, UPDATE, DELETE, or other non-SELECT statement

Execute a statement with multiple parameter sets (batch operations)

Execute query with cursor for large result sets

Bulk import data to a table using COPY

Bulk export data from a table using COPY

List all tables in a schema

Get column metadata for a table

Get detailed information about a table including constraints and indexes

Create a new table

Drop a table

Truncate a table (remove all rows)

List all schemas in the database

Create a new schema

Drop a schema

List all databases in the PostgreSQL server

List all indexes in a schema

Create an index on a table

Drop an index

List all views in a schema

Create a view

Drop a view

List all sequences in a schema

Get the next value from a sequence (nextval)

Get the current value from a sequence (currval)

Set the current value of a sequence (setval)

List all functions in a schema

Call a PostgreSQL function

List all constraints for a table

List all triggers in a schema

List all installed extensions

Create/install an extension

List all database users

List all database roles

Explain a query's execution plan

Vacuum a table to reclaim storage and update statistics

Analyze a table to update statistics

Begin a new transaction

Commit the current transaction

Rollback the current transaction