Db Testing | Skills Pool

스킬 파일

Db Testing

Test, debug, and validate database connectivity and queries. Use when diagnosing connection errors, testing configurations, or validating queries before deployment.

saajunaid0 스타2026. 2. 20.

직업
카테고리: 데이터베이스 도구

스킬 내용

Database Testing Skill

Specialized skill for testing, debugging, and validating database connectivity and queries.

When to Use

User reports database connection errors
Testing a new database configuration
Validating queries before deployment
Debugging data retrieval issues
Verifying authentication configuration

Steps

Step 1: Network Connectivity Check

# Test if server is reachable
ping <DB_HOST>

# Test database port
# SQL Server: 1433, PostgreSQL: 5432, MySQL: 3306
telnet <DB_HOST> <DB_PORT>

Step 2: Connection String Validation

Check environment configuration:

관련 스킬

DB_HOST=<server_name>
DB_NAME=<database_name>
DB_USER=<username>
DB_PASSWORD=<password>
DB_DRIVER=<driver_name>

# Generic connection test pattern
import os