ChicagoRuby x Prairie Postges @ Deinde Financial

Speakers: 🎤 Steven Zelaznik (in person) - Ask Me Anything: Building a Postgres analytics MCP into a legacy Rails app This talk will cover some of the basics about building any sort of MCP tool into a Rails app. Some concerns we'll be taking care of: 1) Authentication and authorization of the MCP 2) Setting up restricted users in Postgres so no PII is ever exposed and no data is rewritten 3) Putting in a preflight "EXPLAIN" query to reject any query that's too expensive 4) Giving users the option to cancel a long running query This simple use case will cover a lot of different parts of MCP, for example, setting up MCP tools and prompts. A lot of what we're doing for the client is helping the client take a vague question such as "How many drivers were denied last year" and instructing the chatbot to ask at least 3 clarifying follow up questions before exploring the Rails code base to return a suggested SQL query to run. This talk will be a 2 parter. Part One: Building an MCP tool into a Rails App Part Two: Postgres Analytics Exploration Location: Deinde Financial - 120 S. LaSalle St., Suite 1600, Chicago, IL 60603 Location Details: In person attendees MUST Register/RSVP with your First + Last name For folks who would rather not have their Meetup Display name be first + last name OR for folks who do NOT have a meetup account. Please RSVP via this form (https://forms.gle/oKbX26tQXDNBhBdH6 ) Valid Photo ID required upon checkin. Note: Our host location also requires us to send a list of attendees ahead of time to get them registered with building security, so please update your Meetup name to your first + last name. (If not comfortable with doing so, feel free to DM (me) Michelle or email [email protected] and title the email 'October 2026 ChicagoRuby Meetup' with your First + Last name or your First + email so that we can get you registered with building security for the event.) For remote attendance: Join us via the following Zoom URL. We want to hear from you! Interested in speaking but unsure what to talk about? Interested in hearing a specific topic? We have compiled a list of potential topic ideas that members of the community are interested in learning more about. See: this google spreadsheet for potential talk topic ideas. For moderation purposes, this spreadsheet is only available for comments and admins will add ideas from comments onto the list. Reach out to Michelle ([email protected]) if you have any questions.