cctvQL

What it does

cctvQL is an open source conversational query layer for CCTV systems. Ask questions like "Were there any people at the front door last night?" and get real answers from Frigate, Hikvision, Synology, Dahua, ONVIF cameras, and more. Works with local LLMs (Ollama) or cloud (OpenAI, Claude). Integrates with Home Assistant and ioBroker. Supports face recognition, push notifications, and multi-camera setups. 100% open source, self-hosted, privacy-first.

Conversational query layer for CCTV and surveillance systems — ask questions in plain English, get answers from Frigate, ONVIF, and more. - arunrajiah/cctvql

• 
  qqqa – A fast, stateless LLM-powered assistant for your shellNov 2025 · github.com · ▲165

  I built qqqa as an open-source project, because I was tired of bouncing between shell, ChatGPT / the browser for rather simple commands. It comes with two binaries: qq and qa. qq means "quick question" - it is read-only, perfect for the commands I always forget. qa means "quick agent" - it is qq's sibling that can run things, but only after showing its plan and getting an approval by the user. It is built entirely around the Unix philosophy of focused tools, stateless by default - pretty much the opposite of what most coding agent are focusing on. Personally I've had the best experience…

• 
  A data viewer for choosing Frigate-compatible IP camerasAug 2026 · github.com · ▲48

  Open database of 8,000+ CCTV camera specs across 130+ brands, with Frigate and ONVIF/RTS integration, CC0 - ch-bas/cctv-camera-database

• 
  SnapQL – Desktop app to query Postgres with AI2025 · github.com · ▲104

  SnapQL is an open-source desktop app (built with Electron) that lets you query your Postgres database using natural language. It’s schema-aware, so you don’t need to copy-paste your schema or write complex SQL by hand. Everything runs locally — your OpenAI API key, your data, and your queries — so it's secure and private. Just connect your DB, describe what you want, and SnapQL writes and runs the SQL for you.

• 
  answercall.ai2023 · answercall.ai · ▲98

  Your intelligent voice assistant

• 
  OpenChatCutJul 2026 · openchatcut.com · ▲109

  Open-source AI agent video editor with a real timeline

• 
  Open-source Face Recognition on Raspberry Pi 3/42020 · github.com · ▲62

  Open-Source AI Camera Skills Platform, AI NVR & CCTV Surveillance. Local VLM video analysis with Qwen, DeepSeek, SmolVLM, LLaVA, YOLO26. LLM-powered agentic security camera agent — watches, understands, remembers & guards your home via Telegram, Discord or Slack. Pluggable AI skills. OpenAI, Google,

• 
  Spira Maxima▲578

  Video model that turns script into viral social media videos

  AI · 18d ago · spira.ai

• 
  Rill Browser▲540

  The browser where Claude Code and Codex work beside you

  AI · 18d ago · rill.love

• 
  Germany's new sovereign AI model Kolibri▲424

  Kolibri is Aleph Alpha

  AI · 20d ago · tej.as

• 
  Giving Opus 5.5 a simulated paint canvas▲392

  Paintings by AI models: programs run through a simulation of oil paint.

  AI · 21d ago · stillwet.art

• 
  PixVerse R2▲381

  A real-time world model you can explore and change

  AI · 30d ago · world.pixverse.video

• 
  Beam.win▲378

  Run AI agents on one Mac and use its windows on another

  AI · 4d ago · beam.win

• TL
  The load-bearing vocabulary of Claude▲710

  Life & fun · Aug 2026 · louisabraham.github.io

• 
  Hey Noah▲656

  A proactive AI executive assistant for founders

  AI · Aug 2026 · heynoah.io

• 
  Clipto MCP▲655

  Hey HN, We recently built Clipto. It’s a tool that lets you search over terabytes of video, audio, and images on your computer, without relying on the cloud. Motivation: we probably all had this similar experience, we know a moment exists in a video or audio, but finding it takes hours scrubbing the timeline. You can send all the media to process in the cloud, but it’s slow, expensive and raises privacy concerns. So we decided to build our own on-device media search engine. How it works (high level): 1. We ingest video, audio, image; normalize formats via ffmpeg; run content analysis to…

  Work · Aug 2026 · clipto.com

• 
  Simple algorithm and color space to generate diverse skin tones▲627

  Hello HN! I found that picking out plausible but diverse skin tones for my digital art and game development projects was kind of difficult, and I got curious about if there was a way to define a color space that made it easy. I've built a color picker and procedural generation algorithm based on the space as well as a bunch of other fun js features and demos throughout the page that use the equations. If you find it interesting, I have lots of explanations of how I built it and what properties the space has. The methodology might be a bit shaky, but hopefully the result is as helpful for…

  Life & fun · Aug 2026 · toneyalexander.github.io

• 
  AdAnt AI▲620

  Claude for viral, high-converting social ads

  AI · Aug 2026 · adant.ai

• 
  Astute▲606

  Automate your B2B brand going viral, with new media creators

  AI · Aug 2026 · company-app.joinastute.com