Daniele Scasciafratte

PicoCode

AI self-hosted Local Codebase Assistant (RAG)

Daniele Scasciafratte / @Mte90Net

Daniele Scasciafratte

  • Co Founder/CTO Codeat
  • Open Source Addicted
  • Mozillian & Mozilla TechSpeaker/Reps (former)
  • WordPress Core Contributor (former)
  • Italian Linux Society council member
  • Amber Lang Co-Maintainer
  • Book Author: "Contribute to Open Source: the right way"

PicoCode

Minimal web UI

PyCharm/IDE integration

Per-project databases with SQLite

Stores vector embeddings in SQLite (sqlite-vector) for fast semantic search

Indexes files and computes embeddings (OpenAI-compatible endpoint, ex: Regolo.AI)

Asynchronous analysis

Production deployment needs health check configuration

File system watcher, caching, logging and rate limiter

Demo Time!

THE END

- github.com/CodeAtCode/PicoCode
- Blog post
- CoPilot example