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. 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 data engineering intelligence layer, avoiding guessing at schemas. Some capabilities that altimate-code adds compared to general coding agents: →SQL anti-pattern detection with 19 rules, 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, which shows credits & expensive queries →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. 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. Data Engineering Companion 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. 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. 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 locally. The altimate-code check command requires no API key — but you can add to unlock LLM-powered suggestions. 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. 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/altima…. 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