What do you want to do?
5 use cases
-
Browse and query a database from the terminal
Open a database in a keyboard-driven client and run SQL with completion and query plans.
- REPO
masumedb/masume - Software and DevOps
- Beginner
View prompt
In the masume repo, open the database at <target> with `masume <target>` and run `select count(*) from <table>`. Expected output: a single row with a count. Verify the count matches the table size reported by the database.
- REPO
-
Let an external agent query allowed databases over MCP
Serve chosen profiles to an agent over stdio with an access level per profile.
- REPO
masumedb/masume - Software and DevOps
- Advanced
View prompt
Using the masume MCP server for profile <profile>, list the tables and report the row count of <table>. Expected output: a table list and one integer. Verify the count by running a matching count query in masume yourself.
- REPO
-
Run SQL in a script and export results to a file
Run statements headless and write CSV, JSON, or Parquet output for a pipeline.
- REPO
masumedb/masume - Software and DevOps
- Intermediate
View prompt
In the masume repo, run `masume run -p <profile> -f json 'select count(*) from <table>'` and report the JSON output. Expected output: one JSON result with a count. Verify that the exit code is 0 before the next step uses the output.
- REPO
-
Compare the schemas of two databases
Find differences in tables, columns, indexes, and constraints between two connections.
- REPO
masumedb/masume - Software and DevOps
- Intermediate
View prompt
Run `masume diff <source> <target>` in the masume repo and summarize the differences found. Expected output: a list of schema differences. Verify one reported difference by inspecting that table in both databases.
- REPO
-
Find and open databases running in local containers
Detect databases in running Docker or Podman containers and open one in the client.
- REPO
masumedb/masume - Software and DevOps
- Beginner
View prompt
In the masume repo, run `masume --detect` and report the databases it lists. Expected output: a list of detected databases. Verify that the database you expect appears, and that the container is running.
- REPO
Quick start with Masume
- Check you have what it needs: A terminal on macOS, Linux, or Windows; A database you can reach, or a local SQLite file; One install method: Homebrew, npm, Go 1.27 or later, or a release package.
- Open masumedb/masume on GitHub and read the README and license.
- Run
brew install masumedb/tap/masume - Run
masume ./notes.dbfor a SQLite file, ormasume postgres://[email protected]:5432/shopfor a URL - Press
?to see the keys andCtrl+Kto open the command palette - Write a query in the editor and run it, then sort or filter the grid
These steps come from our top use case, Browse and query a database from the terminal, which also has a copy-paste agent prompt.
Use this in your AI agent
Ask your agent
Using the Deduped MCP, get the setup steps for masumedb/masume
Add Deduped to Claude Code once
claude mcp add --transport http deduped https://dedupedai.com/mcp
Every Monday: the 5 hottest repos and exactly how to use them. Free, one email a week, unsubscribe anytime.
Get them freeAbout this repo
- Who it is forDevelopers and data people who work with SQL, NoSQL, or key-value databases from a terminal and want one tool for browsing, querying, and scripting.
- Why it is hot107 stars, launched 57 days ago
- LanguageGo
- Sourcegithub.com/masumedb/masume · Back to Hot repos
Requirements
- A terminal on macOS, Linux, or Windows
- A database you can reach, or a local SQLite file
- One install method: Homebrew, npm, Go 1.27 or later, or a release package
Add this badge to your README
Maintain Masume? Show readers where to find these use cases.
Markdown
[](https://dedupedai.com/use-cases/masumedb-masume/?utm_source=github&utm_medium=badge&utm_campaign=masumedb-masume)
HTML
<a href="https://dedupedai.com/use-cases/masumedb-masume/?utm_source=github&utm_medium=badge&utm_campaign=masumedb-masume"><img src="https://dedupedai.com/badge/masumedb/masume.svg" alt="Use cases on Deduped" height="20"></a>
A static image, no tracking script. About the badge
Questions about Masume
What is Masume?
A keyboard-first terminal database client written in Go, with AI chat, notebooks, headless commands, and an MCP server for external agents. It is an open-source project on GitHub: https://github.com/masumedb/masume.
How do I use Masume?
Run brew install masumedb/tap/masume; then run masume ./notes.db for a SQLite file, or masume postgres://[email protected]:5432/shop for a URL; Press ? to see the keys and Ctrl+K to open the command palette. The use cases on this page give the full steps and a copy-paste agent prompt for each job.
Who is Masume for?
Developers and data people who work with SQL, NoSQL, or key-value databases from a terminal and want one tool for browsing, querying, and scripting.
What can I do with Masume?
5 use cases so far, for example: Browse and query a database from the terminal; Let an external agent query allowed databases over MCP; Run SQL in a script and export results to a file. Each has steps and a copy-paste agent prompt.
What do I need to run Masume?
A terminal on macOS, Linux, or Windows; A database you can reach, or a local SQLite file; One install method: Homebrew, npm, Go 1.27 or later, or a release package.
What are alternatives to Masume?
Other hot AI repos in Software and DevOps: Deep Infer, Harness2, Orca, Opencode, Graphify.
Is Masume safe to run?
Deduped does not own, audit or vouch for it. Read the README and license, run it on your own systems first and review every command before you run it.