playbooks

home / skills / partme-ai / full-stack-skills / navicat

navicat skill

/skills/navicat

This skill helps you manage databases with Navicat, execute SQL queries, and leverage Navicat features for efficient database administration.

npx playbooks add skill partme-ai/full-stack-skills --skill navicat

Review the files below or copy the command above to add this skill to your agents.

Files (2)
SKILL.md
702 B
---
name: navicat
description: Provides comprehensive guidance for Navicat database management tool including database connection, query execution, data management, and database administration. Use when the user asks about Navicat, needs to manage databases with Navicat, execute SQL queries, or work with Navicat features.
license: Complete terms in LICENSE.txt
---

## When to use this skill

Use this skill whenever the user wants to:
- [待完善：根据具体工具添加使用场景]

## How to use this skill

[待完善：根据具体工具添加使用指南]

## Best Practices

[待完善：根据具体工具添加最佳实践]

## Keywords

[待完善：根据具体工具添加关键词]

Overview

This skill provides practical, hands-on guidance for using Navicat to manage databases, execute SQL, migrate data, and perform routine administration. It focuses on connection setup, query execution, data import/export, backup/restore, and common troubleshooting. The content is written to help developers and DBAs get productive quickly with Navicat features and workflows.

How this skill works

The skill inspects the user’s intent and environment to recommend Navicat actions: creating and testing connections, writing and running queries, scheduling backups, and transferring data between servers. It explains step-by-step procedures for GUI operations and common CLI/automation patterns where applicable. The guidance highlights settings, options, and checks to avoid data loss and ensure secure connections.

When to use it

  • You need to connect Navicat to MySQL, PostgreSQL, SQL Server, MariaDB, Oracle, or SQLite servers.
  • You want to run, optimize, or debug SQL queries using Navicat’s editor and explain plans.
  • You must migrate data or sync schemas between databases using Navicat’s import/export and data transfer tools.
  • You need to schedule backups, automate scripts, or restore databases safely.
  • You are troubleshooting connection errors, authentication issues, or performance bottlenecks in Navicat.

Best practices

  • Always test new connections with limited privileges before applying wider access.
  • Use parameterized queries and avoid embedding credentials in scripts; prefer SSH/SSL for remote connections.
  • Keep regular backups and verify restore procedures on a staging environment.
  • Use Navicat’s data transfer preview and row count checks before committing large migrations.
  • Version control query scripts and schema changes outside Navicat to maintain auditability.

Example use cases

  • Set up an SSH-tunneled connection to a remote PostgreSQL server and save the profile for repeated use.
  • Import a CSV into a MySQL table with column mapping, validation, and data type conversion.
  • Compare schemas between production and staging and generate a synchronization script.
  • Schedule nightly backups and configure retention while verifying successful job logs.
  • Optimize a slow query using the editor’s formatting, explain plan integration, and index recommendations.

FAQ

Can Navicat connect via SSH and use SSL?

Yes. Navicat supports SSH tunneling and SSL connections—configure the SSH/SSL tabs in the connection dialog and test before saving.

How do I migrate data without downtime?

Use Navicat’s data transfer with incremental sync, perform operations during low-traffic windows, and validate with checksums before switching.