AI tool comparison
RisingWave Agent Skills vs SMF (Semantic Memory Filesystem)
Which one should you ship with? Here is the side-by-side panel verdict, pricing read, reviewer split, and community vote comparison.
Developer Tools
RisingWave Agent Skills
Teach 18 AI coding agents to write correct streaming SQL — no hallucinated syntax
50%
Panel ship
—
Community
Free
Entry
RisingWave's agent-skills package injects streaming SQL expertise into 18 AI coding assistants (Claude Code, GitHub Copilot, Cursor, Windsurf, and more) via the agentskills.io open spec. It ships two skill modules: core RisingWave connectivity and 14 best-practice rules covering CDC ingestion, materialized view patterns, time-windowed aggregations, and common pitfalls. Install via npm CLI which auto-detects which agents you have installed. Apache 2.0 licensed.
Developer Tools
SMF (Semantic Memory Filesystem)
Your filesystem IS the vector database for AI agents
75%
Panel ship
—
Community
Paid
Entry
SMF (Semantic Memory Filesystem) is an open-source Python library that treats the POSIX filesystem as the native memory infrastructure for AI agents. The core bet: instead of standing up a vector database, embedding service, and retrieval pipeline, you model your agent's memory as ordinary directories, files, and symlinks — then use the OS's own tools for retrieval. Entities are directories, relationships are symlinks, metadata is file attributes, and search is built on grep and find. The appeal is radical simplicity. Every developer already understands the filesystem. Memory built on top of it is inspectable with any editor, versionable with git, and portable across machines with rsync. There's no new query language to learn, no vector index to maintain, and no external service to keep running. Dynamis-Labs argues that for many agent memory use cases, semantic similarity search is overkill — you need entity graphs and efficient lookup, which the filesystem already provides. With only 7 stars and created yesterday (April 14), SMF is in very early stages. But the approach has attracted immediate discussion from developers frustrated with the operational overhead of vector databases for relatively structured memory tasks. It's a contrarian bet that's worth watching.
Reviewer scorecard
“AI coding assistants hallucinate streaming SQL constantly — CDC ingestion patterns, windowed aggregations, and materialized view semantics are all places where generic training data fails hard. An installable skill package that auto-detects your agents and patches in correct context is exactly the right fix. Worth adding if you're building on RisingWave.”
“I've been burned too many times by embedding pipelines that drift when models update and vector indexes that mysteriously degrade. Filesystem-native memory is zero-dependency, trivially inspectable, and you can version it with git. For structured agent memory this is genuinely compelling.”
“This only matters if you're already using RisingWave, which is a niche streaming SQL database with a much smaller user base than Postgres or Kafka. Four stars on GitHub suggests the audience is narrow. The agentskills.io spec is interesting as a standard but it's vapor if no one else adopts it.”
“The filesystem approach breaks down the moment you need fuzzy semantic matching — 'find memories related to customer churn' doesn't map to a grep. For anything beyond exact lookup, you're going to bolt on a vector DB anyway and now you have two systems. This is clever for toy agents, not production.”
“Every database, framework, and specialized API is going to need its own skill package for AI coding agents. RisingWave is just the first mover on an inevitable pattern. The open spec is the actually important thing here — it could become how the entire ecosystem teaches agents about domain-specific tools.”
“The insight that the filesystem is a perfectly good entity-relationship store is underappreciated. As agents move toward local-first architectures, having memory that's portable, inspectable, and git-versionable becomes a serious advantage over cloud-hosted vector DBs.”
“Not really in my wheelhouse — streaming SQL and data pipelines are developer infrastructure. But the 'teach your AI assistant the local dialect' concept is one I'd love to see applied to design systems, component libraries, and brand guidelines. Someone should build this for Figma.”
“I love tools that demystify AI plumbing. The idea that agent memory could just be files I can open in a text editor makes the whole system feel less like a black box. This is the kind of transparency that builds trust.”
Weekly AI Tool Verdicts
Get the next comparison in your inbox
New AI tools ship daily. We compare them before you waste an afternoon.