# Query data

Query Altertable from the UI, SQL clients, APIs, and AI tools. Every query runs against the same lakehouse namespace, so Altertable catalogs, object-storage mappings, external catalogs, and product analytics data can be joined in one place.

- **Featured: **[HTTP API](/docs/query-data/http-api.md): Run SQL against Altertable through the HTTP query endpoint and stream lakehouse results into applications and scripts.
- **Best DX: **[Altertable CLI](/docs/developer-tooling/cli.md): Use the Altertable CLI to query lakehouse data, load files, and automate workflows from the terminal.
- **SQL-native: **[DuckDB](/docs/query-data/duckdb.md): Query Altertable databases from DuckDB with the community extension and work with lakehouse data from local SQL workflows.
- **Top Choice: **[Ask Agent](/docs/query-data/ask-agent.md): Ask questions about your Altertable data with an agent that uses shared lakehouse context, SQL, and saved business definitions.
- **Featured: **[Model Context Protocol (MCP)](/docs/query-data/mcp.md): Connect MCP-compatible AI clients to Altertable so agents can query lakehouse data through governed, scoped tools.
- [Object Storage](/docs/query-data/object-storage.md): Query files and Iceberg datasets in S3-compatible object storage from Altertable without moving data into another system.
- [Pandas, Polars, and Ibis](/docs/query-data/pandas-polars-ibis.md): Query Altertable tables with Pandas, Polars, or Ibis using DuckDB's Python client and the Altertable community extension.
- [SQL Explorer](/docs/query-data/sql-explorer.md): Explore Altertable data with SQL, browse catalogs, run DuckDB-powered queries, and inspect results from your lakehouse.
- [Product Analytics](/docs/query-data/product-analytics.md): Analyze product behavior in Altertable with funnels, retention, segmentation, dashboards, and SQL over lakehouse data.
- [OpenTelemetry](/docs/query-data/opentelemetry.md): Query OpenTelemetry logs and traces from Grafana or Altertable Explore, alongside product, operational, and business data.
- [Visualizations](/docs/query-data/visualizations.md): Build insights and dashboards in Altertable to analyze lakehouse data, monitor KPIs, and share trusted results.
- [Adapters](/docs/query-data/adapters.md): Connect SQL clients and data tools to Altertable through Postgres-compatible access and Arrow Flight SQL interfaces.
- [Integrations](/docs/query-data/integrations.md): Connect BI tools, SQL clients, and AI agents to Altertable so every workflow can query the same lakehouse data.