skills.rest
drhalto
drhaltoCOMMUNITY
Explore all skills by this author →
GitHub

Mako Database

Inspect live database schemas, relationships, policies, and RPCs via MCP tools.

51|5|Updated Apr 26, 2026
Search Tags:#database#rls#schema#introspection#stored procedures#foreign keys
One-click install
npx skills add https://github.com/drhalto/agentmako --skill mako-database
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Mako Database
Source: https://github.com/drhalto/agentmako/tree/main/mako-ai-claude-plugin/skills/mako-database
Command: npx skills add https://github.com/drhalto/agentmako --skill mako-database

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps you quickly inspect a live database when you need authoritative answers about tables, columns, relationships, security policies, or stored procedures without guessing from application code.

Core Features & Use Cases

  • Connectivity Check: Verify the database binding is live before doing deeper inspection.
  • Schema Inspection: Review columns, primary keys, indexes, constraints, foreign keys, RLS policies, and triggers.
  • RPC Discovery: Inspect database functions and procedures, including signatures, arguments, return shapes, and security details.
  • Use Case: Ask it when you need to confirm how a table is structured, whether RLS is enabled, or how two tables are related in the database.

Quick Start

Ask the skill to inspect the relevant table or function in the live database and return its schema, constraints, relationships, and RLS details.

Frequently Asked Questions about Mako Database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I inspect a live database schema to review table structures and constraints?▼

To inspect a live database schema, you need a live DB binding and the mako database MCP tools to retrieve table DDL, columns, primary keys, indexes, constraints, and foreign keys directly from the source for accurate structural review.

How can I check if row-level security policies and triggers are enabled on my database tables?▼

You can check if row-level security (RLS) is enabled by running a focused database introspection task that queries the live database binding for RLS policies and trigger details, returning the active security configurations for your tables.

What is the best way to discover stored procedures and inspect database function signatures?▼

The best way to discover stored procedures is through RPC discovery, which inspects live database functions to return their signatures, arguments, return shapes, and security details without needing to guess from application code.

Can I verify database connectivity before running deeper schema introspection queries?▼

Yes, you can verify database connectivity by checking that the live DB binding is active and the mako database MCP tools are connected, ensuring the environment is ready before performing deeper schema, policy, or function retrieval tasks.

How do I analyze foreign keys to understand how two tables are related in my database?▼

To analyze foreign keys and understand table relationships, perform a live database introspection to retrieve the foreign key constraints directly from the schema, mapping how tables connect without manually tracing application code logic.

Related Skills

Explore More Software Engineering Skills→
AJBcodingAJBcoding
4

moai-domain-notion

Automate Notion workspace and database operations through MCP integration.

Community
Advanced
gaoqiongxiegaoqiongxie
1

erd-document

Generate Word/PDF system design documents with ERD diagrams, MySQL DDL, and Java entity code from PRDs.

Community
Intermediate
ethpandaopsethpandaops

optimize-model

Analyze ClickHouse transformation model queries and recommend performance improvements.

Official
Advanced
crgarcia12crgarcia12

data-model-extractor

Extract database schemas and generate Mermaid ER diagrams from ORM models.

Community
Advanced