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.
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"
}
}
}Here is a sample session using Claude Desktop where I create 3 document databases and sync them to the cloud:
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):
- Oganesson (Og) - Element 118
- Radon (Rn) - Element 86
- Xenon (Xe) - Element 54
- Krypton (Kr) - Element 36
- Argon (Ar) - Element 18
- Neon (Ne) - Element 10
- 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?
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?
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:
- Arabian - known for endurance and refinement
- Thoroughbred - famous for racing and athleticism
- Clydesdale - a powerful draft horse
- Quarter Horse - America's versatile stock horse
- Friesian - elegant black horse from the Netherlands
- 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?
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:
- horse_breeds
- elements
- 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:
You can use this URL to access and manage the horse breeds data through the cloud interface.
human (Dec 29, 2024, 04:05 PM)
sync elements db to cloud
assistant (Dec 29, 2024, 04:05 PM)
I'll connect the elements database to the cloud sync service.
The elements database has been successfully connected to the cloud. You can access the dashboard at:
Would you like to sync the cookie_ingredients database as well?
human (Dec 29, 2024, 04:05 PM)
yes
assistant (Dec 29, 2024, 04:05 PM)
I'll connect the cookie_ingredients database to the cloud sync service.
Here's the dashboard URL for the cookie_ingredients database:
Now all three databases (horse_breeds, elements, and cookie_ingredients) are synchronized to the cloud and can be accessed through their respective dashboard URLs.
human (Dec 29, 2024, 04:06 PM)
delete all databases
assistant (Dec 29, 2024, 04:06 PM)
I'll help you delete all three databases.
All three databases have been successfully deleted:
- horse_breeds
- elements
- cookie_ingredients
Let me verify that they're all gone.
Confirmed - there are no remaining databases in the system. Would you like to create any new databases?
Converted to Markdown thanks to: https://simonwillison.net/2024/Aug/8/convert-claude-json-to-markdown/
- prompts
- resources
- multiuser with permissions
- indexing
- generate static websites from Claude Desktop using Firebase npm libraries
pnpm install
pnpm build
pnpm run inspector
# To reset, do: rm -rf ~/.fireproof /tmp/dist~/Library/Application\ Support/Claude/claude_desktop_config.json:
{
"mcpServers": {
"json-db-collections": {
"command": "<base-dir>/mcp-json-db-collection-server/build/index.js"
}
}
}
MIT or Apache 2