Skip to content

Boyce v0.1.0 — First Public Release

Latest
Latest

Choose a tag to compare

View all tags
@Will-Wright Will-Wright released this 24 Mar 06:28
· 28 commits to main since this release
v0.1.0
3bc64f2

Deterministic SQL compiler and semantic protocol for agentic database workflows.

Install

pip install boyce

What's In This Release

  • 8 MCP tools: ingest_source, ingest_definition, get_schema, ask_boyce, validate_sql, query_database, profile_data, check_health
  • 10 source parsers: dbt manifest, dbt project, LookML, raw DDL, SQLite, Django, SQLAlchemy, Prisma, CSV, Parquet
  • Deterministic SQL kernel: Same inputs → same SQL, byte-for-byte, every time. Zero LLM in the compiler.
  • NULL Trap detection: Profiles equality-filtered columns for NULL hazards before the query runs.
  • EXPLAIN pre-flight: Every generated query is validated against the database before returning.
  • Redshift safety linting: Catches Redshift 1.0 incompatibilities at compile time.
  • Dijkstra join resolution: Optimal join paths via weighted semantic graph.
  • Multi-dialect SQL: Redshift, Postgres, DuckDB, BigQuery.
  • Zero-config for MCP hosts: Works with Claude Code, Cursor, VS Code, DataGrip, and any MCP-compatible editor — no API key needed.
  • Setup wizard: boyce init auto-detects your editor, database, and data sources.
  • Auto-discovery: boyce scan ./ finds and ingests your project's schema sources.
  • Version lifecycle: boyce doctor checks environment health, boyce update self-updates.

Quick Start

pip install boyce
boyce init          # configure your editor + database
boyce scan ./       # auto-detect and ingest schema sources
boyce ask "total revenue by customer segment"

Links

License

MIT. The engine is free forever. No paywalls. No open-core bait-and-switch.

Named for Raymond F. Boyce, co-inventor of SQL (1974).

Assets 4
Loading