markdown-body entry-content container-lg" itemprop="text">

Note: This is a read-only subtree split of open-telemetry/opentelemetry-php-contrib.

OpenTelemetry SQL Commenter

OpenTelemetry SQL Commenter for PHP provides a SqlCommenter implementation, enabling you to inject trace and context comments into SQL queries for enhanced observability and distributed tracing.

Installation

Install via Composer:

composer require open-telemetry/opentelemetry-sqlcommenter

Usage

Inject comments into your SQL query as follows:

use OpenTelemetry\SqlCommenter\SqlCommenter;

$comments = [
    'traceparent' => '00-4bf92f3577b34da6a3ce929d0e0e4736-00f067aa0ba902b7-00',
    'custom' => 'value',
];
$query = SqlCommenter::inject($query, $comments);

Configuration

Context Propagators

Set the propagators to use (comma-separated):
```
OTEL_PHP_SQLCOMMENTER_CONTEXT_PROPAGATORS=tracecontext
```
Default: ''
SQL Commenter Attribute

Add SQL comments to DbAttributes::DB_QUERY_TEXT in span attributes:
```
otel.sqlcommenter.attribute = true
```
or via environment variable:
```
OTEL_PHP_SQLCOMMENTER_ATTRIBUTE=true
```
Default: false
Prepend Comments

Prepend comments to the query statement using either a configuration directive:
```
otel.sqlcommenter.prepend = true
```
or via environment variable:
```
OTEL_PHP_SQLCOMMENTER_PREPEND=true
```
Default: false

Development

Install dependencies and run tests from the SqlCommenter subdirectory:

composer install
./vendor/bin/phpunit tests