ERD Online lets AI agents read and edit database schemas via MCP protocol

·1 views

A developer has released ERD Online, an open-source database design tool that integrates with AI coding agents such as Cursor, Claude, and Cline through the Model Context Protocol (MCP). The tool addresses a longstanding gap in database tooling by combining Git-style versioning with real-time collaboration features. Using MCP, AI agents can list projects, retrieve schema data, and propose new versions, but all suggested changes must be reviewed and approved by the human designer before taking effect. This version-controlled approval flow prevents AI agents from silently altering database structures, keeping developers in control. The project is self-hostable, uses an open schema format, and is available on GitHub alongside a live demo requiring no sign-up.

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)

HTML, CSS, and JavaScript: A Practical Beginner's Guide to Building Webpages

A new beginner's guide outlines how every website is built on three core technologies: HTML, CSS, and JavaScript. HTML defines a page's structure using tags and elements, while CSS handles visual styling such as colors, fonts, and layout. JavaScript adds interactivity and logic on top of the static foundation. The guide walks learners through each technology individually before combining them in a hands-on project — a personal task tracker. Only a free text editor like VS Code and a web browser are needed to follow along.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Engineer Builds Hybrid Agentic RAG System Combining FAISS and BM25 for Smarter LLM Retrieval

A developer has designed and documented an Agentic Hybrid Retrieval-Augmented Generation (RAG) architecture that merges dense semantic search via FAISS with exact keyword matching using BM25, aiming to overcome limitations of traditional static RAG pipelines. The system uses an autonomous LLM agent built on the smolagents framework, enabling dynamic decision-making about when and how to retrieve information. During development, the engineer encountered significant challenges running the model locally on CPU, including import errors, latency exceeding 213 seconds per step, and model hallucinations. These issues were resolved by switching to a cloud-hosted model, Qwen2.5-72B-Instruct, and applying dynamic score normalization with a weighted fusion parameter. The research also outlines a future roadmap for scaling the architecture toward knowledge graphs, multi-agent consensus systems, and automated valuation frameworks.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

How to Structure Figma Variables for Scalable UI Design Systems

Figma variables store reusable design values such as colors, spacing, and typography that can be applied consistently across components and prototypes. Organizing these variables into structured collections — including design tokens, global primitives, language, and private primitives — helps teams manage complexity as projects scale. Figma supports six variable types: color, number, string, boolean, timing, and easing, each serving a distinct design or prototyping purpose. Unlike styles, which store fixed sets of design properties, variables enable dynamic changes such as switching between light and dark modes or adapting layouts for different devices. A well-structured variable system reduces redundancy, simplifies updates, and ensures design consistency across an entire product library.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Semantic vs. Prompt Caching: Finding the Cost Break-Even Point for LLM Apps

A technical analysis published on DEV Community argues that rising LLM API costs are fundamentally an architecture problem rather than a prompt engineering issue. Two main caching strategies are compared: provider-side prompt caching, which reuses repeated input prefixes at 10% of normal token cost, and semantic caching, which uses embedding similarity to skip LLM calls entirely for near-duplicate queries. The study uses a reproducible benchmark of 1,200 queries across four repetition patterns to measure where each approach becomes cost-effective. Prompt caching suits workloads with long, repeated system prompts, while semantic caching eliminates redundant calls but risks returning wrong answers on false-positive matches. The analysis concludes that neither technique touches prompt content directly, making them complementary to — not substitutes for — prompt optimization.

0 comments Read more at DEV Community