PartyTown Postgres MCP Skill

Database Overview

PostgreSQL + Microsoft Orleans. All domain state lives in a single grain storage table. The database also has the Apache AGE graph extension installed, currently unused.

Key constraint: grain state is stored as payloadbinary bytea — you cannot read actual state content via SQL. Queries are limited to grain identity and metadata.

Schema Discovery

Before writing domain queries, discover what's there:

-- All tables (domain tables are in ag_catalog schema)
SELECT schemaname, tablename FROM pg_tables
WHERE schemaname NOT IN ('pg_catalog', 'information_schema')
ORDER BY schemaname, tablename;

-- Columns for any table
SELECT column_name, data_type
FROM information_schema.columns
WHERE table_schema = 'ag_catalog' AND table_name = 'orleansstorage'
ORDER BY ordinal_position;

-- All grain types present
SELECT DISTINCT graintypestring FROM ag_catalog.orleansstorage;

PartyTown Postgres MCP Skill

Database Overview

PostgreSQL + Microsoft Orleans. All domain state lives in a single grain storage table. The database also has the Apache AGE graph extension installed, currently unused.

Key constraint: grain state is stored as payloadbinary bytea — you cannot read actual state content via SQL. Queries are limited to grain identity and metadata.

Schema Discovery

Before writing domain queries, discover what's there:

-- All tables (domain tables are in ag_catalog schema)
SELECT schemaname, tablename FROM pg_tables
WHERE schemaname NOT IN ('pg_catalog', 'information_schema')
ORDER BY schemaname, tablename;

-- Columns for any table
SELECT column_name, data_type
FROM information_schema.columns
WHERE table_schema = 'ag_catalog' AND table_name = 'orleansstorage'
ORDER BY ordinal_position;

-- All grain types present
SELECT DISTINCT graintypestring FROM ag_catalog.orleansstorage;

Column	Type	Purpose
`graintypestring`	varchar	Grain type — primary filter
`grainidn0`	bigint	Numeric grain key (part 1)
`grainidn1`	bigint	Numeric grain key (part 2)
`grainidextensionstring`	varchar	String grain key (null for numeric-keyed grains)
`serviceid`	varchar	Service instance (`'default'`)
`payloadbinary`	bytea	Serialized state — not readable via SQL
`modifiedon`	timestamp	Last write time
`version`	integer	Optimistic concurrency version

`graintypestring`	Role
`partyRoot`	Root grain tracking all Parties
`PartyTown.Grains.PartyGrain`	A single Party (owns ChatGroups and Personas)
`persona`	A single Persona (AI character)
`personaRoot`	Root grain tracking all Personas

Partytown Postgres

PartyTown Postgres MCP Skill

Database Overview

Schema Discovery

Partytown Postgres

PartyTown Postgres MCP Skill

Database Overview

Schema Discovery

Core Domain Table: `ag_catalog.orleansstorage`

Known Grain Types

Useful Queries

Limitations

Other Tables

Postgres Patterns

Postgres Patterns

Database Migrations

Postgres Patterns

Postgres Patterns

Jpa Patterns

Partytown Postgres

PartyTown Postgres MCP Skill

Database Overview

Schema Discovery

Partytown Postgres

PartyTown Postgres MCP Skill

Database Overview

Schema Discovery

Core Domain Table: ag_catalog.orleansstorage

Known Grain Types

Useful Queries

Limitations

Other Tables

Postgres Patterns

Postgres Patterns

Database Migrations

Postgres Patterns

Postgres Patterns

Jpa Patterns

Core Domain Table: `ag_catalog.orleansstorage`