Model Context Protocol and Fireproof Demo: JSON Document Collection Server

<h1>

❤️

</h1>

This is an example of how to use a Fireproof database in a Model Context Protocol server (used for plugging code and data into A.I. systems such as Claude Desktop).

This server:

allows the creation of multiple "JSON Document Databases" (implemented using Fireproof)
implements basic CRUD operations (Create, Read, Update, Delete) within any database and the ability to query documents sorted by any field.
* allows sharing of any database with others using the Fireproof Cloud service and dashboard

Prior art: This is based on https://github.com/fireproof-storage/mcp-database-server - it adds multiple databases plus the ability to sync to the cloud.

Running the Server

First, build it:

npm install
npm build

To use with Claude Desktop, add the server config:

On MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json

On Windows: %APPDATA%/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "json-db-collections": {
      "command": "<base-dir>/mcp-json-db-collection-server/build/index.js"
    }
  }
}

Sample Claude Desktop chat session

Here is a sample session using Claude Desktop where I create 3 document databases and sync them to the cloud:

1. Chat Session: Database of Elements

human (Dec 29, 2024, 03:59 PM)

create a json document database named elements

assistant (Dec 29, 2024, 04:00 PM)

I'll help you create a JSON document database named "elements".

The database has been created successfully. You can now use this database to store and manage JSON documents. Would you like to add any documents to it?

human (Dec 29, 2024, 04:00 PM)

add noble gases from period table as individual docs

assistant (Dec 29, 2024, 04:00 PM)

I'll help you add the noble gases as individual documents to the elements database. I'll include key properties for each noble gas.

I've added all seven noble gases (Helium, Neon, Argon, Krypton, Xenon, Radon, and Oganesson) to the database. For each element, I included:
- Name and symbol
- Atomic number and mass
- Period, group, and block
- Electron configuration
- Melting and boiling points (in Kelvin)
- Density (in g/cm³)

Note that for Oganesson, some physical properties are marked as null since it's a synthetic element with very short half-life and its properties aren't well-determined experimentally.

Would you like to query any specific information about these noble gases from the database?

human (Dec 29, 2024, 04:01 PM)

show docs

assistant (Dec 29, 2024, 04:01 PM)

I'll query all the documents from the elements database, sorted by atomic number.

Here are all the noble gases in the database, listed in order of atomic number (from highest to lowest):

1. Oganesson (Og) - Element 118
2. Radon (Rn) - Element 86
3. Xenon (Xe) - Element 54
4. Krypton (Kr) - Element 36
5. Argon (Ar) - Element 18
6. Neon (Ne) - Element 10
7. Helium (He) - Element 2

Each document contains detailed information about the element, including its atomic mass, density, melting and boiling points (where known), and electron configuration. Would you like to examine any specific properties or compare certain aspects of these elements?

2. Chat Session: Database of Cookie Ingredients

human (Dec 29, 2024, 04:01 PM)

create json document db called cookie_ingredients

assistant (Dec 29, 2024, 04:01 PM)

I'll create a new JSON document database called "cookie_ingredients".

The database has been created successfully. Would you like to add any ingredients to it?

human (Dec 29, 2024, 04:02 PM)

add ingredients from chocolate chip cookie recipe as individual docs

assistant (Dec 29, 2024, 04:02 PM)

I'll add common ingredients for chocolate chip cookies as individual documents with their typical measurements and properties.

I've added all the essential ingredients for a classic chocolate chip cookie recipe. For each ingredient, I included:
- Name and amount
- Unit of measurement
- Type (dry, wet, leavening, etc.)
- Purpose in the recipe
- Possible substitutes
- Weight measurements
- Important notes about usage

Would you like to query any specific information about these ingredients from the database?

human (Dec 29, 2024, 04:02 PM)

show ingredients as table

assistant (Dec 29, 2024, 04:03 PM)

I'll query the ingredients and format them as a markdown table.

| Ingredient | Amount | Unit | Type | Purpose | Weight/Unit |
|------------|--------|------|------|---------|------------|
| All-Purpose Flour | 2¼ | cups | dry | structure | 120g/cup |
| Unsalted Butter | 1 | cup | fat | texture and flavor | 227g/cup |
| Granulated Sugar | ¾ | cup | sweetener | sweetness and texture | 200g/cup |
| Brown Sugar | ¾ | cup | sweetener | moisture and flavor | 220g/cup |
| Large Eggs | 2 | whole | binding | structure and richness | 50g each |
| Vanilla Extract | 1 | teaspoon | flavoring | flavor enhancement | 5g/tsp |
| Salt | 1 | teaspoon | seasoning | flavor enhancement | 6g/tsp |
| Baking Soda | 1 | teaspoon | leavening | rise and spread | 4.8g/tsp |
| Chocolate Chips | 2 | cups | mix-in | flavor and texture | 170g/cup |

I've organized the ingredients by type and included their amounts, units, purposes, and weight measurements. Would you like to see any additional details about specific ingredients?

3. Chat Session: Database of Horse Breeds

human (Dec 29, 2024, 04:03 PM)

create new json document db called horse_breeds

assistant (Dec 29, 2024, 04:03 PM)

I'll create a new JSON document database for horse breeds.

The database has been created successfully. Would you like to add some horse breeds to it?

human (Dec 29, 2024, 04:03 PM)

yes

assistant (Dec 29, 2024, 04:04 PM)

I'll add several popular horse breeds with their key characteristics, origins, and typical uses.

I've added six distinctive horse breeds to the database:
1. Arabian - known for endurance and refinement
2. Thoroughbred - famous for racing and athleticism
3. Clydesdale - a powerful draft horse
4. Quarter Horse - America's versatile stock horse
5. Friesian - elegant black horse from the Netherlands
6. Appaloosa - known for spotted patterns and Native American heritage

Each entry includes information about:
- Origin and type
- Height range (in hands - where 1 hand = 4 inches)
- Common colors
- Physical characteristics
- Typical uses
- Temperament
- Notable traits

Would you like to see the information presented in a specific way or learn more about any particular breed?

4. Chat Session: Sync to Cloud

human (Dec 29, 2024, 04:04 PM)

list json document dbs

assistant (Dec 29, 2024, 04:04 PM)

I'll list all the JSON document databases that have been created.

We have three JSON document databases:
1. horse_breeds
2. elements
3. cookie_ingredients

Each database contains documents related to its specific theme:
- horse_breeds has information about different horse breeds
- elements contains data about noble gases
- cookie_ingredients has details about chocolate chip cookie ingredients

Would you like to query any specific information from these databases?

human (Dec 29, 2024, 04:04 PM)

sync horse_breeds to cloud

assistant (Dec 29, 2024, 04:04 PM)

I'll help you connect the horse_breeds database to cloud sync service.

The horse_breeds database has been successfully connected to the cloud. You can access the dashboard using the URL provided above. This will allow you to view and manage your horse breeds data through the cloud interface. Would you like to sync any other databases to the cloud as well?

human (Dec 29, 2024, 04:05 PM)

show url

assistant (Dec 29, 2024, 04:05 PM)

Here's the dashboard URL for the horse_breeds database: