Extend with optional resource backed session storage

[jarlah]

Code of Conduct

• I agree to follow this project's Code of Conduct

AI Policy

• I agree to follow this project's AI Policy, or I agree that AI was not used while creating this issue.

Is your feature request related to a problem? Please describe.

Ill link to this issue in anubis:

zoedsoupe/anubis-mcp#125

The core issue is that Claude Code doesnt understand HTTP 400 or 404, and doesnt reinitialize the session. It keeps the session forever until reconnected in /mcp.

By introducing postgres backed session storage, the sessions would live as long as they are configured to live, but across server restarts and hickups.

Describe the solution you'd like

A postgres backed session storage with an ash resource.

Describe alternatives you've considered

No response

Additional context

No response

[zachdaniel]

👍 here for it. PRs welcome!