More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    MCP Database Assistant for MySQL & PostgreSQL

    1

    Guide your AI agent through schema exploration, SQL queries, and authorized data changes using mcp-database.

    $3

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned

    MCP Database Assistant for MySQL & PostgreSQL

    Example session with this skill installed

    List the available connections and databases. Then inspect public.orders
    in the sales database on the production_db connection.

    Show its columns, data types, nullability, defaults, primary key,
    and foreign keys. Use read-only schema queries and report access errors.List the available connections and databases. Then inspect public.orders
    in the sales database on the production_db connection.

    Show its columns, data types, nullability, defaults, primary key,
    and foreign keys. Use read-only schema queries and report access errors.

    • Read your context and instructions
    • Compiled the mcp database assistant

    Illustrative example using fictional database names and schema.

    This is not a recorded live session.

    Available connections and databases

    ConnectionDatabase typeDatabase
    production_dbPostgreSQLanalytics
    production_dbPostgreSQLsales
    local_devMySQLstaging

    These entries represent discovered database names. Listing alone does
    not verify connectivity to every database.

    Table structure: sales → public.orders

    Inspection target: connection production_db, database sales,
    schema public, table orders.

    ColumnData typeNullableDefault
    idbigintNoNone
    customer_idbigintNoNone
    total_amountnumeric(12,2)No0
    statuscharacter varying(20)No'pending'
    created_attimestamp with time zoneNonow()

    Keys and relationships

    • Primary key: orders.id

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Give your AI agent a practical workflow for working with MySQL and PostgreSQL through the mcp-database MCP server.

    This companion skill explains how to discover database connections, inspect schemas, construct queries, and verify authorized data changes. It also covers situations that need extra care, including truncated results, connection failures, and queries whose execution outcome is uncertain.

    What it helps your agent do

    • Select the intended connection and database.
    • Inspect tables, columns, keys, and relationships before querying.
    • Produce focused queries and accurate aggregate reports.
    • Preview affected records before authorized changes.
    • Check affected-row counts and verify results afterward.
    • Avoid blindly repeating queries after a lost connection.
    • Recognize when a task requires a dedicated transaction connection.

    What’s included

    • A reusable SKILL.md with tool usage and workflow instructions.
    • A setup reference covering configuration and server compatibility.

    Requirements

    A separately installed and configured mcp-database MCP server, your own database credentials, and an AI client that supports the required MCP tools and skill instructions.

    This package provides agent instructions. It does not include a hosted database service, install the server automatically, or replace database permissions.

    Requires a separately configured, compatible mcp-database server and user-provided database access.

    Only one SQL statement is supported per tool call. Connections are pooled, so transactions, temporary tables, and session variables cannot reliably span separate calls.

    Dangerous SQL keywords are blocked by default, but this does not enforce read-only access or replace database permissions.

    Displayed results may be truncated. Connection failures can leave query outcomes uncertain; verification is needed before considering another attempt.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed 28 days ago

    Requires

    Database MCP
    Node.js 18+
    npm
    MySQL or PostgreSQL database
    Node.js
    db-access

    Permissions

    Read Files
    Network Access
    Terminal / Shell
    Write Files

    Normal operation uses the configured server's list_databases and execute_sql tools. Network access is used by the server for configured database connections and optional SSH tunnels. Terminal and file-write access are needed only when the user requests setup assistance. File access is limited to bundled references and the user-selected server checkout and configuration files. Provide credentials locally in the server configuration. Database writes require user authorization and sufficient database privileges; analysis-only use can use a read-only database account.

    Listed28 days ago

    What's inside

    Frequently Asked Questions

    It guides your agent through database discovery, schema inspection, SQL reporting, and authorized data corrections. The workflow emphasizes checking table structure before writing SQL, previewing proposed changes, and verifying results. These instructions help reduce mistakes but do not guarantee correct SQL or prevent every unsafe operation.

    The skill supports MySQL and PostgreSQL through the mcp-database server. Your agent must be able to load the skill instructions and call the server's MCP tools. Client configuration varies, and compatibility has not been verified with every agent.

    You need Node.js 18+, npm, and a locally built and configured mcp-database server (package name: db-access). Register the server with your MCP client and configure access to your database. SSH access is needed only if your connection uses a tunnel. The skill includes setup guidance, but it does not include database hosting, credentials, or an automatically installed server.

    New in Data & Databases