慣性聚合 高效追讀感興趣之博客、新聞、科技資訊
閱原文 以慣性聚合開啟

推薦訂閱源

博客园 - 司徒正美
V
V2EX
T
Tailwind CSS Blog
有赞技术团队
有赞技术团队
aimingoo的专栏
aimingoo的专栏
Apple Machine Learning Research
Apple Machine Learning Research
IT之家
IT之家
Blog — PlanetScale
Blog — PlanetScale
A
About on SuperTechFans
月光博客
月光博客
T
The Blog of Author Tim Ferriss
宝玉的分享
宝玉的分享
Martin Fowler
Martin Fowler
博客园 - 聂微东
The GitHub Blog
The GitHub Blog
V
Visual Studio Blog
WordPress大学
WordPress大学
酷 壳 – CoolShell
酷 壳 – CoolShell
Engineering at Meta
Engineering at Meta
GbyAI
GbyAI

DEV Community

Authentication Security Deep Dive: From Brute Force to Salted Hashing (With Java Examples) Why AI Systems Don’t Fail — They Drift Spilling beans for how i learn for exam😁"Reinforcement Learning Cheat Sheet" I Replaced Chrome with Safari for AI Browser Automation. Here's What Broke (and What Finally Worked) How Python Borrows Other People's Work The $40 Architecture: Processing 1 Billion API Requests with 99.99% Uptime Vibe Coding: A Workflow Guide (From Zero to SaaS) Most webhook security guides protect the wrong side. The scary part is delivery. Headless CMS for TanStack Start: Build a Blog with Cosmic EU Age Verification App "Hacked in 2 Minutes" — What Actually Happened Comfy Cloud’s delete function does not actually remove files Running AI Models on GPU Cloud Servers: A Beginner Guide Event-driven media intelligence with AWS Step Functions and Bedrock I scored 500 AI prompts across 8 quality dimensions — here's what broke How to Call Google Gemini API from Next.js (Free Tier, No Backend Needed) The Portal Protocol: Reclaiming Human Connection in the Age of AI How to Fix Your Team's Scattered Knowledge Problem With a Self-Hosted Forum Intro to tc Cloud Functors: A Graph-First Mental Model for the Modern Cloud Designing Multi-Tenant Backends With Both Ownership and Team Access I Built a Neumorphic CSS Library with 77+ Components — Here's What I Learned PostgreSQL Performance Optimization: Why Connection Pooling Is Critical at Scale Cómo construí un SaaS multi-rubro para gestionar expensas en Argentina con FastAPI + Vue 3 🚀 I Built an Ethical Hacking Scanner Tool – Open Source Project I Replaced /usage and /context in Claude Code With a Single Statusline A Pythonic Way to Handle Emails (IMAP/SMTP) with Auto-Discovery and AI-Ready Design I Collected 8.9 Million Polymarket Price Points — Here's What I Found About How Markets Really Move EcoTrack AI — Carbon Footprint Tracker & Dashboard Everyone's Using AI. No One Agrees How. 5 self-hosted ebook managers worth trying in 2026 Building Your First AI Agent with LangChain: From Chatbot to Autonomous Assistant Common SOC 2 Failures (Real World) Stop Vibe-Checking Your AI App: A Practical Guide to Evals How to Use SonarQube and SonarScanner Locally to Level Up Your Code Quality Your Next To-Do App Is Dead — I Replaced Mine with an OpenClaw AI Sign a Nostr event in 60 lines of Python using coincurve — no nostr-sdk, no nbxplorer, no rust toolchain ITGC Audit Explained Like You’re in Big 4 Patch Tuesday abril 2026: Microsoft parcha 163 vulnerabilidades y un zero-day en SharePoint Stop scraping everything: a better way to track competitor price changes Listing on MCPize + the Official MCP Registry while routing payments OUTSIDE the marketplace — how I kept 100% of my x402 revenue Building an AI-Powered Risk Intelligence System Using Serverless Architecture Why We Ripped Function Overloading Out of Our AI Toolchain Testing AI-Generated Code: How to Actually Know If It Works SaaS Churn Is Killing Your Business. Here Is What to Do About It (Without a Support Team) The Speed of AI Is No Longer Linear - And Self-Improving Models Are Why How to Implement RBAC for MCP Tools: A Practical Guide for Engineering Teams From Standard Quote to Persuasive Proposal: AI Automation for Arborists I built a CLI that scaffolds complete multi-tenant SaaS apps Axios CVE-2025–62718: The Silent SSRF Bug That Could Be Hiding in Your Node.js App Right Now The dashboard that ended our friendship Data Pipelines Explained Simply (and How to Build Them with Python)
吾之智囊,于汝之数据,目盲矣。然有法可解此困。
Paulo Anchet · 2026-05-24 · via DEV Community

人工智能,已为吾辈撰述软件之常道。其能读码,献策补漏,释疑解惑,速逾多数Stack Overflow之答。然犹有之事,非其独能:察吾辈之实据。

此实为较之常情更甚之困。

而能实察之虫豸助人者

汝得哨兵警报。汝将堆栈轨迹粘贴于克劳德。其错误、其参数、其行号。彼读之尽,妄测其故。

然其弊在于此。不过臆测耳。彼不知用户记录之状。彼不知关联对象之态。彼不知此乃偶发之故,抑或众用户恒于此聚。

汝遂为是物之手足。运行查询,复将结果粘贴,再行数事。此流程非至劣,然AI可为之半事,今未尽其能也。

若以MCP服务器联于汝之Rails应用,则可自察。其能述汝之模型,引相关记录,复报若此:"遇此谬误者,皆onboarding_completed_at为空,而"subscription_active诚然。观其流程,似有缺环。无往复,无复制粘贴查询结果。

汝之AI驱使之少吏

同疾异境:尔三月前已发一功能,今产品部有人欲知其是否实用。

此常需撰一查询,构一简报,或向执掌分析者呈一票。此皆非难事,然其间阻隔,致所问多寂寂而亡,少有得解。

若数据可通过MCP得见,汝但问之。"近三十日内,几何用户已用新导出之功能?依计划分之。" 调用适器,计数归组,应答若瞬。无SQL,无仪表盘,无久候。

此乃知码库之AI与识产线实况之AI之别。

何不直予其数据库URL?

善问也。简言之,直取数据库即直用SQL,直用SQL则无所不可。或越表联结非所宜联,或询主库而非副库,或无记所取之迹。

activerecord-mcp则使AI由应用层得入。询则经ActiveRecord,以哈希条件验实列名。敏感之列如password_digest、令牌及密钥,于数据触及数据库之前,即遭正则拒止列表所阻,于输出之际亦被剥离,以防万一。凡事皆以只读角色运行,此乃默认之规。OAuth 2.1令牌限权,使MCP凭据不得渗漏至堆栈之他处。

此即汝应施于任何内部API之访问控制,亦施于汝之AI工具。

启程之始

# Gemfile
gem "activerecord-mcp"
gem "doorkeeper"

入全景模式 出全景模式

bundle install
bin/rails generate doorkeeper:install
bin/rails generate doorkeeper:migration
bin/rails db:migrate
bin/rails generate rails_mcp:install

入全景模式 出全景模式

限其所欲显之模,挂之,而联之:

claude mcp add --transport http my-app https://your-app.com/mcp \
  --header "Authorization: Bearer $MY_APP_TOKEN"

入全景模式 出全景模式

全设于github.com/pauloancheta/activerecord-mcp