:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.
Python ab-testingai-analyticsanalyticscdpdata-warehouseexperimentsfeature-flagsjavascriptproduct-analyticspythonreactsession-replaysurveystypescriptweb-analytics
from posthog.hogql.context import HogQLContext
from posthog.hogql.database.database import Database
from posthog.sync import database_sync_to_async
@database_sync_to_async
def serialize_database_schema(database: Database, hogql_context: HogQLContext):
"""Unified serialization of the database schema for the LLM."""
# Simplify the schema description by only including the most important core tables, plus all warehouse tables and views
serialized_database = database.serialize(
hogql_context,
include_only={
"events",
"groups",
"persons",
*database.get_warehouse_table_names(),
*database.get_system_table_names(),
*database.get_view_names(),
},
)
schema_description = "\n\n".join(
(
f"Table `{table_name}` with fields:\n"
+ "\n".join(f"- {field.name} ({field.type})" for field in table.fields.values())
for table_name, table in serialized_database.items()
)
)
return schema_description