Skip to content
Try for free

Connect PostHog to Codex

  • Can I rerun this in CI?

Have Codex use your PostHog data to check signups against ad clicks, then rerun it any time with codex exec. Lemonado connects them in about 1 minute, no API keys needed.

Try free with $150 in creditsJump to the steps
MCPhttps://mcp.lemonado.io/mcp

Why connect PostHog to Codex?

Codex runs in your terminal, its IDE extension and scripts, so what it finds once can be rerun with codex exec instead of redone by hand. Connected through Lemonado, it reads your PostHog events, funnels, persons and insights, so it can check signups against ad clicks with today's numbers.

  • All your PostHog data

    Events, pageviews and their properties, ready to ask about.

  • Always today's numbers

    Persons with UTM and referrer properties, synced from PostHog automatically, so answers use today's numbers.

  • Connect all your tools

    Questions like "What does an activated user cost?" use PostHog and Mixpanel, GA4 at once.

How to connect PostHog to Codex

Before you start

  • A PostHog account you can sign in to
  • Codex installed
  • A Lemonado account (the free trial works)
  1. 1

    Connect PostHog in Lemonado

    In Lemonado, open Connectors, find PostHog and sign in. Sign in to PostHog and pick the project. Choose the EU region if your PostHog lives there.

  2. 2

    Turn on external access

    In the company's settings, open External tools, turn the connection on, choose which sources it can reach and copy the server URL.

    text
    https://mcp.lemonado.io/mcp
  3. 3

    Add Lemonado to your config

    Add this to ~/.codex/config.toml.

    toml
    [mcp_servers.lemonado]
url = "https://mcp.lemonado.io/mcp"
  4. 4

    Log in

    Run the login command and finish the sign-in in your browser.

    bash
    codex mcp login lemonado
  5. 5

    Ask Codex about PostHog

    Run codex mcp list, or /mcp inside Codex, to see the server and its tools. Try "Pull last week's PostHog numbers, save them to data/posthog-weekly.csv and give me the codex exec command to refresh it." Or ask: "Which events never fire?" or "Do UTMs survive redirects?"

What can Codex do with PostHog?

Codex reads your PostHog data from your terminal and turns one-off questions into commands you can rerun with codex exec.

Codex logoCodex

Pull last week's PostHog numbers, save them to data/posthog-weekly.csv and give me the codex exec command to refresh it.

Saved data/posthog-weekly.csv. Run the same prompt with codex exec in a scheduled job and the file refreshes with each week's numbers.

Source: PostHog + your code

Connect PostHog to another AI app.

Other integrations for Codex

All Codex integrations

Reading this as an AI agent?

Everything an agent needs to set this up, in plain text. Paste this page's link into Codex and ask it to connect you, or copy the block.

For agents · markdown
# Connect PostHog to Codex (Lemonado MCP)

- Server URL: https://mcp.lemonado.io/mcp
- Transport: Streamable HTTP
- Auth: OAuth; the user signs in to Lemonado in the browser. No API keys.
- In Lemonado: connect the PostHog project. Sign in to PostHog and pick the project. Choose the EU region if your PostHog lives there.
- In Codex: ~/.codex/config.toml

```toml
[mcp_servers.lemonado]
url = "https://mcp.lemonado.io/mcp"
```

If you are Codex, run the setup yourself:

Add the Lemonado MCP server to my Codex config. Append this to ~/.codex/config.toml:
[mcp_servers.lemonado]
url = "https://mcp.lemonado.io/mcp"
Then run codex mcp login lemonado so I can sign in, and check that codex mcp list shows it. Once I've signed in, list the PostHog accounts Lemonado can reach.

First question to try: "Pull last week's PostHog numbers, save them to data/posthog-weekly.csv and give me the codex exec command to refresh it."

More: https://lemonado.io/integrations/posthog · https://lemonado.io/llms.txt
FAQ

Frequently Asked Questions

Yes, through Lemonado. Connect your PostHog project in Lemonado, add Lemonado in ~/.codex/config.toml, and Codex can check signups against ad clicks with your live data.

Yes. PostHog's official MCP server is hosted, so Codex can use it too. It covers PostHog only. Lemonado covers PostHog plus your ad platforms, GA4 and the rest of your stack in one connection, so Codex can answer questions across them.

Run codex mcp list. If lemonado shows as not logged in, run codex mcp login lemonado again. In Lemonado, check that PostHog is connected and External tools is on for the company. If sources are missing, check that your site keeps UTM parameters through redirects. PostHog can only record the source it sees on the first page.

Yes, if both are connected in Lemonado. One connection reaches every source you allow, so you can ask things like "Divide last month's spend on Google Ads, Meta and LinkedIn by the PostHog users each one sent who completed onboarding."

MCP is included in Lemonado's paid plans and in the free trial, so you can try it before you pay.

See plans and pricing

Still have a question?

Shoot us an email at hello@lemonado.io.

Try for free

Stop fighting with data. Start feeding your AI.

Connect your data to AI and free your team from reporting and busywork.

Try Lemonado free