←back to thread

133 points bloppe | 1 comments | | HN request time: 0.212s | source

I've been working with the Featureform team on their new open-source project, [EnrichMCP][1], a Python ORM framework that helps AI agents understand and interact with your data in a structured, semantic way.

EnrichMCP is built on top of [MCP][2] and acts like an ORM, but for agents instead of humans. You define your data model using SQLAlchemy, APIs, or custom logic, and EnrichMCP turns it into a type-safe, introspectable interface that agents can discover, traverse, and invoke.

It auto-generates tools from your models, validates all I/O with Pydantic, handles relationships, and supports schema discovery. Agents can go from user → orders → product naturally, just like a developer navigating an ORM.

We use this internally to let agents query production systems, call APIs, apply business logic, and even integrate ML models. It works out of the box with SQLAlchemy and is easy to extend to any data source.

If you're building agentic systems or anything AI-native, I'd love your feedback. Code and docs are here: https://github.com/featureform/enrichmcp. Happy to answer any questions.

[1]: https://github.com/featureform/enrichmcp

[2]: https://modelcontextprotocol.io/introduction

Show context
aolfat ◴[] No.44321365[source]
Woah, it generates the SQLAlchemy automatically? How does this handle auth/security?
replies(1): >>44321508 #
1. simba-k ◴[] No.44321508[source]
Yep, we can essentially convert from SQLAlchemy into an MCP server.

Auth/Security is interesting in MCP. As of yesterday a new spec was released with MCP servers converted to OAuth resource servers. There's still a lot more work to do on the MCP upstream side, but we're keeping up with it and going to have a deeper integration to have AuthZ support once the upstream enables it.