skills.rest
ProfoundLogic
ProfoundLogicOFFICIAL
Explore all skills by this author →
WebsiteGitHub

sql

Execute parameterized SQL statements against IBM i DB2 and Microsoft SQL Server.

Updated Feb 17, 2026
Search Tags:#database#sql#query#data retrieval#sql execution#parameterized query
One-click install
npx skills add https://github.com/ProfoundLogic/coderflow-demo-setup --skill sql-profoundlogic
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql
Source: https://github.com/ProfoundLogic/coderflow-demo-setup/tree/main/skills/sql
Command: npx skills add https://github.com/ProfoundLogic/coderflow-demo-setup --skill sql-profoundlogic

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill allows users to execute SQL queries against various database systems directly from the command line, simplifying data retrieval and manipulation.

Core Features & Use Cases

  • Execute SQL Queries: Run any valid SQL statement.
  • Parameterized Queries: Safely execute queries with dynamic parameters to prevent SQL injection.
  • Multiple Output Formats: Get results as JSON (default) or formatted tables.
  • Connection Management: Use named connections defined in your configuration for easy access to different databases.
  • Use Case: Retrieve customer data from a production database, filter it by a specific status, and display it in a human-readable table format.

Quick Start

Execute the SQL query SELECT * FROM QIWS.QCUSTCDT LIMIT 5 using your default database connection.

Frequently Asked Questions about sql

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

FAQPage Schema
How do I execute SQL queries against a database from the command line?▼

You can execute SQL queries against database systems directly from the command line using this tool. It supports data retrieval and manipulation tasks, allowing you to run statements and view results quickly without a full database client.

Does this tool support parameterized queries to prevent SQL injection?▼

Yes, it supports parameterized queries to prevent SQL injection. You can safely execute queries with dynamic parameters, ensuring your data retrieval and manipulation tasks remain secure against malicious input.

Can I use SQL execution to retrieve data from an IBM i DB2 database?▼

Yes, you can retrieve data from an IBM i DB2 database. The tool supports connection management via configuration files, allowing you to execute SQL statements across various database providers including IBM i DB2 and Microsoft SQL Server.

What output formats are available when running SQL statements for reporting?▼

When running SQL statements for reporting, the available output formats are JSON and formatted tables. JSON is the default format, but you can easily display your data retrieval results in a human-readable table format.

How do I manage connections to different databases for data retrieval?▼

You manage connections to different databases for data retrieval by using named connections defined in your configuration files. This allows easy access and switching between various database providers during SQL execution.

Related Skills

Explore More Software Engineering Skills→
Shamrock2245Shamrock2245
1

connecting-streamlit-to-snowflake

Establishes Snowflake database connections from Streamlit apps using st.connection and session writes.

Community
Intermediate
MacPhobosMacPhobos

Reporting Pipelines

Execute CLI tools or scripts to export timestamped reports in CSV, JSON, or Markdown formats.

Community
Intermediate
Jiale-ZouJiale-Zou

chart-extract

Extract tabular data from experimental results into JSON and Markdown tables.

Community
Intermediate
ajshedivyajshedivy
3

database-plan-cache

Manage IBM i SQL plan cache snapshots, event monitors, and maintenance procedures.

Community
Advanced