Perplexity API – sonar-pro-2 vs RisingWave Agent Skills

“The primitive here is clean and nameable: a hosted search-grounded LLM endpoint that returns citations alongside completions, OpenAI-compatible, no custom retrieval stack required. The DX bet is the right one — they absorbed the complexity of crawling, indexing, and freshness so you don't have to wire together Tavily, a chunker, and a reranker just to answer 'what happened last Tuesday.' The 200k context window means you can actually pass a thread of prior citations back in without chunking gymnastics. The first-10-minutes test passes: if you've used the OpenAI SDK, you swap the base URL and model name, and you have grounded responses with source URLs. The one honest caveat is cost: at $5 per 1000 searches stacked on top of token pricing, this is not a tool for bursty free tiers. Build your own? You'd spend a week wiring Brave Search + LangChain + a citation parser to get 70% of this. The specific decision that earns the ship: they exposed citations as structured data in the response object, not buried in prose — that's the detail that proves the API was designed for downstream use, not just chat.”

“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.”

“Category is search-augmented LLM API; direct competitors are Tavily's search API plus any hosted LLM, Brave Search API plus GPT-4o, and — crucially — OpenAI's own web search tool that now ships natively in the API. That last one is the kill condition: OpenAI's web search feature is already eating this market, and Google's Gemini with grounding is right behind it. The scenario where sonar-pro-2 breaks is enterprise scale — at $5 per 1000 queries, a product doing 10M queries a month is looking at $50k in search costs alone before tokens, and Perplexity doesn't have the negotiating leverage of a hyperscaler to discount that. My 12-month prediction: OpenAI ships a more capable grounded model natively and undercuts on price, forcing Perplexity to compete on citation quality and freshness latency rather than just availability. What would have to be true for me to be wrong: Perplexity's crawler has meaningfully better freshness and coverage than what OpenAI indexes, and they can prove it with methodology. Right now I don't see that data. Ship for now, but watch the OpenAI roadmap closely.”

“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 buyer here is a developer or ML team at a startup building a research or knowledge product, pulling from product budget — that's a real buyer, but it's a small TAM and a fickle one. The pricing architecture stacks two meters on top of each other — tokens and search queries — which means cost is hard to predict and hard to explain in a unit economics model for any product built on top of it. The moat question is the one that sinks this: Perplexity's defensible position is their crawler and index freshness, but they've never published data on how that compares to Bing or Google's index, which is what OpenAI and Gemini are grounding against. When the underlying search infrastructure of a hyperscaler is your actual competition, 'we shipped first' is not a moat. The business survives if Perplexity wins at the application layer AND the API layer simultaneously — that's two hard markets at once. The specific thing that would need to change: a credible data partnership or proprietary index that hyperscalers can't replicate, plus pricing that scales with customer success rather than query volume.”

“The thesis here is falsifiable: in 2-3 years, the default architecture for production AI applications includes real-time web grounding as a first-class primitive, not a bolt-on retrieval step, and teams that don't want to maintain search infrastructure will pay for it as a service. That bet is directionally correct — the trend line is the collapse of the gap between 'static model knowledge' and 'live world state,' and sonar-pro-2 is on-time to that trend, not early. The second-order effect worth naming: if this API wins adoption, Perplexity becomes infrastructure for a layer of the AI stack that's currently invisible to end users — the citation graph they're building across millions of developer queries becomes a proprietary signal about what information developers and their users actually need to verify, which is a data asset nobody else is accumulating in this specific form. The dependency that has to hold: Perplexity must stay independent long enough to compound that data advantage before OpenAI or Google makes grounded APIs table stakes at zero marginal cost. The future state where this is infrastructure: every AI assistant with a factual use case routes through a search-grounded API layer, and Perplexity is the AWS of that layer. That's a real bet, not a vibe.”

“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.”

“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.”