SShortSingh.
Back to feed

Schemagate library offers zero-import tools to filter database schema for AI agents

0
·5 views

A developer built Schemagate, a Python library designed to restrict which database tables an AI agent can see based on the caller's permissions. The core problem it addresses is that agents often expose schema objects users are not authorized to access, and wiring a fix into an existing agent takes significant effort. To lower adoption friction, the library now offers five interfaces — including a CLI demo, a select command, and a local studio UI — that require no Python imports at all. In benchmark tests, the tool reduced average prompt size by 75.6%, selecting around 9 relevant objects from a 42-object schema instead of passing the entire schema to the model. A browser-based version running on six bundled schemas is also publicly available, with a JavaScript port of the selector validated against 1,789 test cases to match the Python version exactly.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Log in to join the discussion and vote.

Log in

Related stories

0
ProgrammingDEV Community ·

How to Build a Privacy-First Freelance Rate Calculator Using Plain HTML and JS

A tutorial published on DEV Community outlines how freelancers can build a dependency-free, browser-based hourly rate calculator using plain HTML and JavaScript. The guide argues that the common method of dividing desired income by working hours is flawed, as it ignores unbillable time, operating costs, and financial uncertainty. The proposed tool makes all assumptions transparent by displaying intermediate values such as billable hours, required monthly revenue, and contingency amounts alongside the final rate. Built as a static page, the calculator requires no server, framework, or user account, keeping sensitive financial inputs entirely within the browser. The article also recommends separating business logic from display code to make the calculator easier to test, extend, and adapt for related workflows like quotes or invoicing.

0
ProgrammingDEV Community ·

Solo dev builds pay-to-message Telegram chat app with direct TON blockchain payments

A mobile developer built Centence, a Telegram Mini App where sending a message costs cryptocurrency and the recipient earns the payment directly. The app runs on the TON blockchain, routing funds wallet-to-wallet via TON Connect, so the platform never holds user money. This non-custodial design was a deliberate workaround to avoid money-operator regulations, app store payment rules, and Telegram's Stars policy for digital goods. The developer takes a 10% fee as a separate output of each transaction, with the remaining 90% going straight to the recipient. The project was built solo over a few weeks, with an LLM assisting in coding, and all debugging was done using real on-chain transactions.

0
ProgrammingDEV Community ·

AI subscribers question value as ads, slowdowns, and expiring 'unlimited' plans mount

Paying users of AI tools including ChatGPT and Cursor are voicing growing dissatisfaction over perceived declines in service quality and changing subscription terms. A ChatGPT Go subscriber reported ads appearing inside paid conversations, a practice absent at sign-up, and said the change prompted them to trial rival services for the first time. Cursor Pro users flagged that 'unlimited' auto-mode access was expiring, effectively downgrading plans they had budgeted around. Even top-tier subscribers paying the highest rates complained of slower responses and increased errors from newer models. The complaints, drawn from Reddit and Hacker News posts dated 26 August, reflect a broader pattern of AI platforms tightening terms after using generous early offers to build user habits.

0
ProgrammingDEV Community ·

Developer builds AI-curated hourly e-ink newspaper fed by 100 RSS sources

A software developer has built an automated news briefing system that pulls around 120 items from roughly 100 RSS feeds every hour and uses Claude Haiku on AWS Bedrock to select, rank, and summarize stories. The pipeline renders output as a 480x800 one-bit image for an e-ink desk reader, and also produces PDF editions for reMarkable and Kindle devices. A custom deduplication system merges near-identical stories from different outlets using headline entity overlap, ensuring the same news event is not repeated across sources. The entire pipeline has been exposed as both a public API and an MCP server so AI agents can query the curated briefings programmatically. The developer noted that within a day of listing the MCP server in public registries, traffic consisted almost entirely of automated bots rather than human users.