Support the postgres wire protocol

[jgpruitt]

Description

Using SQL to query traces is a truly remarkable feature. Currently, it appears to be locked behind the UI or MCP, though. I want to use a query tool like psql. I LIVE in psql. I am primarily using Claude Code with MCP to explore my tracing data, but I'm fully capable of writing my own SQL queries to get exactly what I want. Supporting the postgres wire protocol and exposing an endpoint that I could use with general-purpose query tools like psql would unlock so much power.

[alexmojaki]

Currently, it appears to be locked behind the UI or MCP, though

No, you can use https://logfire.pydantic.dev/docs/how-to-guides/query-api/

(but btw please set a min_timestamp when you do)

[MasterOdin]

Thanks for the link to the docs to the API. I share John's desire to be able to connect to the query API directly within a SQL client as that'd be really cool I think to leverage the tooling that exists around SQL query writing into interacting with the API (vs using a HTTP client as suggested in the docs).

I made a PoC of what that could look like with regards to the postgresql wire protocol to make @jgpruitt happy, which is available at https://github.com/timescale/logfire-pg.

[samuelcolvin]

oh nice! We actually had this before - @adriangb implemented the entire PG wire protocol in python. We removed it when we switched database.

It's definitely something we want to re-add, but haven't had time yet.

I always throught it would be better implemented in Rust than Python, maybe @adriangb would be keener on doing it in rust now?

[adriangb]

@MasterOdin curious how you'd feel about using Arrow Flight SQL as the wire protocol instead?