iodbc-dsn-manager

Configure and validate ODBC DSNs on macOS or Linux using iODBC or unixODBC.

35|8|Updated Dec 19, 2025
One-click install
npx skills add https://github.com/OpenLinkSoftware/ai-agent-skills --skill iodbc-dsn-manager
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: iodbc-dsn-manager
Source: https://github.com/OpenLinkSoftware/ai-agent-skills/tree/main/iodbc-dsn-manager
Command: npx skills add https://github.com/OpenLinkSoftware/ai-agent-skills --skill iodbc-dsn-manager

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Configuring and validating ODBC Data Source Names (DSNs) across macOS and Linux can be error-prone and complex. This skill automates discovery, inspection, testing, and modification of DSNs using iODBC or unixODBC, reducing setup time and troubleshooting effort.

Core Features & Use Cases

  • List all DSNs from system and user locations and show their drivers.
  • Inspect DSN and driver configuration details to verify correctness.
  • Test live connectivity using iodbctest/iodbctestw or isql/iusql and report results.
  • Add or edit DSN entries in odbc.ini across macOS/Linux environments.
  • Troubleshoot common DSN issues with guided steps and recommendations.

Quick Start

Begin by asking the skill to list DSNs, then select a DSN to test and configure as needed.

Frequently Asked Questions about iodbc-dsn-manager

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

FAQPage Schema
How do I list and inspect ODBC DSN configurations on macOS or Linux?

ODBC DSN configurations can be discovered and inspected by listing all DSNs from system and user locations, showing their associated drivers, and verifying configuration details in odbc.ini and odbcinst.ini files.

How do I test ODBC DSN connectivity using iodbctest or isql?

You can test ODBC DSN connectivity by running live tests using iodbctest, iodbctestw, isql, or iusql, which validates the connection and reports results to confirm your DSN setup is functioning correctly.

Does this ODBC DSN manager work with both iODBC and unixODBC drivers?

Yes, this ODBC DSN manager supports both iODBC and unixODBC, allowing you to configure, validate, and troubleshoot DSNs across macOS and Linux environments regardless of which driver manager you use.

How do I add or edit ODBC DSN entries in odbc.ini across different platforms?

You can add or edit ODBC DSN entries in odbc.ini across macOS and Linux by specifying the DSN parameters, which automatically modifies the configuration file in the correct system or user scope.

What steps should I take to troubleshoot ODBC DSN connection issues?

To troubleshoot ODBC DSN connection issues, you can follow guided diagnostic steps that inspect configurations, run connectivity tests using iodbctest or isql, and provide recommendations for resolving common setup errors.