Simon Späti 🏔️2d ago
Altimate-code: a new open-source code editor for data engineering based on opencode. Easter comes early for every developer this year. Altimate-code is an OSS agentic code editor that works in the terminal, based on the admired OpenCode AI editor, with dedicated data engineering features.
Show threadSimon Späti 🏔️2d ago
The difference to general AI coding agents such as Claude or Codex is that Altimate is focused on SQL and data engineering tasks, with an understanding of the data stack and integration in tooling. Altimate gives any LLM a deterministic DE intelligence layer, avoiding guessing at schemas.
Show threadSimon Späti 🏔️2d ago
Some capabilities over a general coding agents: →SQL anti-pattern detection, confidence-scored →Column-level lineage, automatic from SQL, any dialect →Schema-aware autocomplete based on live-indexed warehouse metadata →Cross-dialect SQL translation for popular DWHs →FinOps & cost analysis
Show threadSimon Späti 🏔️
→dbt integration with parsing manifest, model scaffolding, and lineage →Observability, with local-first tracing capabilities Under the hood, altimate-code runs a Rust-native SQL analysis engine (altimate-core) that does AST (Abstract Syntax Tree)-based parsing.
Mar 25 at 2:29pmWeb
Show threadSimon Späti 🏔️2d ago
Very similar to SDF (now dbt Fusion) and SQLMesh, altimate-code has #deterministic SQL linter capabilities, not based on scanning the full project via bash that might take minutes, but in seconds and sub-seconds.
Show threadSimon Späti 🏔️2d ago
Altimate is backed by DuckDB for local SQL validation and Zod for runtime type-safe parameter validation across all tool integrations. It works with dbt, DuckDB, Airflow, Dagster, and all your data tools from the data OSS data ecosystem.
Show threadSimon Späti 🏔️2d ago
It integrates with any DE stack and any LLM provider you know of. JIRA, GitHub, and soon Kubernetes and ServiceNow, so you have an agentic coding partner for all things data engineering, plus ticket management with Infra.
Show threadSimon Späti 🏔️2d ago
Security is a big part of agents, and altimate-code includes a permission guard system. If you have sensitive PII data, Altimate can run entirely locally, pointing it at DuckDB or hooking it up to Ollama. PII detection uses regex patterns, and the schema is cached in an embedded SQLite database.
Show threadSimon Späti 🏔️2d ago
It uses Tree-sitter (behind VS Code, Zed, Neovim) to parse and analyze shell commands for safety before execution to detect redirects, file patterns, and potential working directory risks.
Show threadSimon Späti 🏔️2d ago
But try it out yourself. Run a `/discover` or a `/trace`, or just check out the command palette, it's fully open source and available at github.com/AltimateAI/...

GitHub - AltimateAI/altimate-c...
Show threadSimon Späti 🏔️2d ago
I personally love the three modes, besides `Plan` and `Builder`, it also has an `Analyst` role, where it explores data, selects queries, and makes analyses - like a real analyst. #genai #dataengineering #paidpartnership