Schema | pg-mnemosyne-mcp

pg-mnemosyne-mcp

Describes the environment variables required to run the server.

Name	Required	Description	Default
`PG_BASE_DSN`	Yes	Standard PostgreSQL connection string: postgresql://<USERNAME>:<PASSWORD>@<HOST>:<PORT>/<DEFAULT_DB>

Features and capabilities supported by this server

Capability	Details
`tools`	{ "listChanged": false }
`prompts`	{ "listChanged": false }
`resources`	{ "subscribe": false, "listChanged": false }
`experimental`	{}

Functions exposed to the LLM to take actions

Name	Description
create_project_dbB	Creates a new PostgreSQL database for a project.
init_schemaC	Initializes the base 'records' table in the specified database.
init_todo_schemaC	Initializes a professional 'tasks' table in the specified database.
init_coordination_schemaC	Initializes the 'agent_sessions' table for multi-agent coordination.
update_agent_sessionA	Updates or registers the active task and state of an agent in the database (thread-safe upsert).
get_active_sessionsC	Retrieves all registered agent coordination sessions ordered by last active time.
add_columnB	Adds a new column to a table dynamically.
run_sqlC	Executes arbitrary SQL queries and returns results as JSON.
add_recordC	Adds a new memory/task record.
get_recordsC	Retrieves recent records from the database.
delete_recordC	Deletes a record from the database by its ID.
update_recordC	Updates a record in the database by its ID. Only non-None fields will be updated.

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/Janadasroor/pg-mnemosyne-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server