MCP (Model Context Protocol) solves a fundamental problem: how do you give an AI model access to external data like databases, files, or APIs without embedding everything in each request? Introduced by Anthropic in November 2024, MCP is now mature enough (15+ months old) for serious production use. Think of it like a USB-C port for AI—a standardized way to connect AI models to external systems.
(more…)Archive for the ‘Database Management Systems’ Category
What is MCP and why is it important
Posted in ai, Database Management Systems, Still-coding, tagged ai, artificial-intelligence, Database, Fintech, llm, MCP, Technology on February 9, 2026| Leave a Comment »
Converting a database from CouchDB to Mongodb
Posted in Database Management Systems, Still-coding, tagged ai, artificial-intelligence, CouchDB, MongoDB, node.js, NOSQL, programming, SQL, Technology, typescript on August 28, 2025| Leave a Comment »
When I began the project I am currently working on (more details will be provided next month – probably), it was initially intended as a small test to determine the capabilities of AI. Over the last six months it has turned into something that we might take further.
But I hit a problem. As a little hobby project I chose the database I really really like – CouchBD. CouchDB is elegant, simple yet very functional and efficient. Close to the perfect database management system (DBMS). But to take it further I need to involve other developers and it turs out that CouchDB skills are few and far between. Truly it is the Betamax of DBMSs.
(more…)AI to the rescue – Part 2.
Posted in Database Management Systems, Still-coding, Technology, tagged ai, ChatGPT, Database, Gemini, JSON Schema, programming, SQL on January 11, 2025| Leave a Comment »
In a previous post I showed how an AI system (ChatGPT) was an easy way of converting an SQL Schema to a JSON-Schema. It was very successful and could save hours of donkey-work when dealing with a legacy database. I am coding in TypeScript so I asked for a TypeScript schema as well. It also did that perfectly.
I asked Gemini to do the same job.
(more…)AI to the rescue
Posted in Database Management Systems, Still-coding, tagged Database, json, JSON Schema, programming, SQL, sql-server on January 9, 2025| Leave a Comment »
I have been working on my hobby project, which is a generic database updating tool. It uses an extension of the JSON-Schema standard. But how do you deal with a new database from a legacy database.
I found a really simple solution, I asked ChatGTP to produce a JSON-Schema based on a database dump – which happily is a set of SQL statements.
(more…)IT Pioneers: Charles Bachman – Database Pioneer
Posted in Database Management Systems, History, tagged CODASYL, Database, History, IT Pioneers, SQL on September 19, 2023| Leave a Comment »
If you are asked to name the most important pioneer in database development, the name Edgar Codd is probably the first name that comes to mind. He pioneered the concept of relational database. But another person deserves credit as well. Nearly a decade earlier Charles Bachman did fundamental work, developing the first database management system.
(more…)I don’t need a schema for NOSQL, right?
Posted in Database Management Systems, Still-coding, Technology, tagged json-schema, NOSQL, SQL on July 20, 2023| Leave a Comment »
A schema means different things for an SQL and a NOSQL database management system. If you are using SQL, you have to tell the system about the format of the data before you can use – that is the schema. When it comes to NOSQL databases everything is different. You don’t need a schema, you simply present data and the system stores it in whatever format you send it.
Each document in a collection1 can be a different layout and different types of data. The flexibility of NOSQL databases suggests that data design is less important. For example I read: “… since NoSQL doesn’t necessitate the need for a schema, you avoid the expense and time of that initial design stage.”
I don’t think so
(more…)I don’t need a schema for NOSQL, right?
Posted in Database Management Systems, Still-coding, Technology, tagged Database, express, json, node.js, NOSQL, sailsjs, schema, SQL on May 4, 2023| Leave a Comment »
A schema means different things for an SQL and a NOSQL database management system. If you are using SQL, you have to tell the system about the format of the data before you can use – that is the schema. When it comes to NOSQL databases everything is different. You don’t need a schema, you simply present data and the system stores it in whatever format you send it.
Each document in a collection1 can be a different layout and different types of data. The flexibility of NOSQL databases suggests that data design is less important. For example I read: “… since NoSQL doesn’t necessitate the need for a schema, you avoid the expense and time of that initial design stage.”
I don’t think so
(more…)
Bob Browning's blog 