What problems does this skill help solve?

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.

Which agents and databases does this skill support?

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.

What do I need before using this skill?

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.

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

Connection	Database type	Database
production_db	PostgreSQL	analytics
production_db	PostgreSQL	sales
local_dev	MySQL	staging

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.

Column	Data type	Nullable	Default
id	bigint	No	None
customer_id	bigint	No	None
total_amount	numeric(12,2)	No	0
status	character varying(20)	No	'pending'
created_at	timestamp with time zone	No	now()

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.

How to use

Skills on Agensi run inside your AI agent. Copy the prompt, paste it into your agent, and it connects to Agensi and installs this skill for you. If a payment is needed, your agent shows it to you first.

Reviews

No reviews yet

Be one of the first to try it. Every listed skill passes our trust checks below.

Security scanned

Passed 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.

MCP Database Assistant for MySQL & PostgreSQL