본문으로 건너뛰기
cccskills
무료GitHub에 공개

mssql

mssql (node-mssql, Node.js 向け Microsoft SQL Server クライアント) の API リファレンス。

tedious / msnodesqlv8 ドライバー、SQL Server / T-SQL / TDS 接続、ConnectionPool、 `sql.query` タグ付きテンプレート、bulk insert、Table-Valued Parameter (TVP)、 prepared statement、isolation level、Diagnostics Channel、Azure AD 認証、CLI。

Drizzle ORM 経由の SQL Server 利用 (drizzle-orm/mssql-core) は別スキル drizzle が対象。

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

연동 도구Azure
설치 방법 보기

포함된 파일(88)

  • SKILL.md6.5 KB
  • references/configuration/azure-ad-connection-string.md2.2 KB
  • references/configuration/connection-string-formats.md794 B
  • references/configuration/general-options.md2.6 KB
  • references/configuration/README.md566 B
  • references/connections/advanced-pool-management.md2.2 KB
  • references/connections/close.md869 B
  • references/connections/connect.md1.7 KB
  • references/connections/connection-pools.md1.9 KB
  • references/connections/connection-validation.md2.2 KB
  • references/connections/events.md1.3 KB
  • references/connections/global-connection-pool.md2.0 KB
  • references/connections/global-pool-single-instance.md2.1 KB
  • references/connections/parse-connection-string.md1.1 KB
  • references/connections/pool-properties.md1.7 KB
  • references/connections/README.md1.5 KB
  • references/connections/result-value-manipulation.md1.1 KB
  • references/data-types-results/affected-rows.md1.4 KB
  • references/data-types-results/data-types.md3.1 KB
  • references/data-types-results/duplicate-column-names.md4.1 KB
  • references/data-types-results/geography-geometry.md2.2 KB
  • references/data-types-results/json-support.md1.3 KB
  • references/data-types-results/metadata.md1.9 KB
  • references/data-types-results/README.md1.2 KB
  • references/data-types-results/response-schema.md1.2 KB
  • references/data-types-results/table-valued-parameter.md1.9 KB
  • references/drivers/msnodesqlv8.md3.7 KB
  • references/drivers/README.md353 B
  • references/drivers/tedious.md3.3 KB
  • references/errors-diagnostics/detailed-sql-errors.md1.7 KB
  • references/errors-diagnostics/diagnostics-channel.md4.9 KB
  • references/errors-diagnostics/error-codes.md2.3 KB
  • references/errors-diagnostics/errors.md1.7 KB
  • references/errors-diagnostics/identifier-rules.md3.4 KB
  • references/errors-diagnostics/informational-messages.md1.0 KB
  • references/errors-diagnostics/README.md1.1 KB
  • references/errors-diagnostics/sql-injection.md1.6 KB
  • references/getting-started/config-object-example.md1.6 KB
  • references/getting-started/connect-string-example.md1018 B
  • references/getting-started/installation.md597 B
  • references/getting-started/README.md877 B
  • references/getting-started/sql-server-prerequisites.md317 B
  • references/getting-started/windows-authentication-msnodesqlv8.md1.4 KB
  • references/migration/README.md215 B
  • references/migration/version-changes.md7.8 KB
  • references/requests/batch.md1.9 KB
  • references/requests/bulk.md3.9 KB
  • references/requests/cancel.md1.3 KB
  • references/requests/execute.md2.5 KB
  • references/requests/input.md2.1 KB
  • references/requests/output.md1.1 KB
  • references/requests/pipe.md2.1 KB
  • references/requests/query.md2.8 KB
  • references/requests/README.md1.1 KB
  • references/requests/replace-input.md1.3 KB
  • references/requests/replace-output.md1.1 KB
  • references/requests/request.md1.8 KB
  • references/requests/to-readable-stream.md1.7 KB
  • references/transactions/begin.md2.0 KB
  • references/transactions/commit.md936 B
  • references/transactions/prepare.md1.4 KB
  • references/transactions/prepared-statement-execute.md2.5 KB
  • references/transactions/prepared-statement-input.md1.0 KB
  • references/transactions/prepared-statement-output.md1.0 KB
  • references/transactions/prepared-statement.md2.4 KB
  • references/transactions/README.md1.0 KB
  • references/transactions/rollback.md1.0 KB
  • references/transactions/transaction.md4.0 KB
  • references/transactions/unprepare.md1.0 KB
  • samples/advanced-pool-management.md2.0 KB
  • samples/async-await.md1.2 KB
  • samples/bulk-insert.md856 B
  • samples/callbacks.md1.4 KB
  • samples/config.md654 B
  • samples/diagnostics-opentelemetry.md1.4 KB
  • samples/global-connection-pool.md1.2 KB
  • samples/global-pool-single-instance.md1.5 KB
  • samples/prepared-statement.md1.0 KB
  • samples/promises-queries.md775 B
  • samples/promises-stored-procedures.md841 B
  • samples/README.md2.4 KB
  • samples/streaming.md2.3 KB
  • samples/table-valued-parameter.md1.4 KB
  • samples/tagged-template-literals.md909 B
  • samples/transaction.md1.8 KB
  • scripts/cli.md2.0 KB
  • scripts/install.md750 B
  • scripts/README.md269 B

SKILL.md(원문)

설치하기 전에 에이전트에게 전달되는 지시 내용을 확인할 수 있습니다.

mssql API リファレンス

mssql (node-mssql) — tediousjs 製の Node.js 向け Microsoft SQL Server クライアント(対象バージョン v12.7.9)。 tedious / msnodesqlv8 ドライバー、ConnectionPool、Request / Transaction / PreparedStatement による T-SQL 実行、データ型・エラー処理・診断を中核とする API 設計・実装時に参照する。

ディレクトリ構成

skills/mssql/
  SKILL.md
  references/
    getting-started/
      README.md
      installation.md
      sql-server-prerequisites.md
      connect-string-example.md
      config-object-example.md
      windows-authentication-msnodesqlv8.md
    configuration/
      README.md
      general-options.md
      connection-string-formats.md
      azure-ad-connection-string.md
    drivers/
      README.md
      tedious.md
      msnodesqlv8.md
    connections/
      README.md
      connection-pools.md
      global-connection-pool.md
      global-pool-single-instance.md
      advanced-pool-management.md
      result-value-manipulation.md
      connection-validation.md
      events.md
      connect.md
      close.md
      pool-properties.md
      parse-connection-string.md
    requests/
      README.md
      request.md
      execute.md
      input.md
      output.md
      replace-input.md
      replace-output.md
      to-readable-stream.md
      pipe.md
      query.md
      batch.md
      bulk.md
      cancel.md
    transactions/
      README.md
      transaction.md
      begin.md
      commit.md
      rollback.md
      prepared-statement.md
      prepared-statement-input.md
      prepared-statement-output.md
      prepare.md
      prepared-statement-execute.md
      unprepare.md
    data-types-results/
      README.md
      data-types.md
      json-support.md
      geography-geometry.md
      table-valued-parameter.md
      response-schema.md
      affected-rows.md
      duplicate-column-names.md
      metadata.md
    errors-diagnostics/
      README.md
      errors.md
      error-codes.md
      detailed-sql-errors.md
      informational-messages.md
      sql-injection.md
      identifier-rules.md
      diagnostics-channel.md
    migration/
      README.md
      version-changes.md
  samples/
    README.md
    config.md
    async-await.md
    promises-queries.md
    promises-stored-procedures.md
    tagged-template-literals.md
    callbacks.md
    streaming.md
    global-connection-pool.md
    global-pool-single-instance.md
    advanced-pool-management.md
    transaction.md
    prepared-statement.md
    bulk-insert.md
    table-valued-parameter.md
    diagnostics-opentelemetry.md
  scripts/
    README.md
    install.md
    cli.md

探索手順

タスクからカテゴリを引き、カテゴリの README.md で目的のページを特定する:

  1. 下記マッピング表でタスクに対応するカテゴリを探す
  2. そのカテゴリの references/{category}/README.md を参照して目的のページを特定する
  3. 該当ページの .md を Read して詳細を確認する

タスク → カテゴリ マッピング

タスクカテゴリ参照 README
インストール手順・接続の最初の一歩を知りたいgetting-startedreferences/getting-started/README.md
接続文字列・config オプションを調べたいconfigurationreferences/configuration/README.md
Azure AD 認証の接続文字列形式を知りたいconfigurationreferences/configuration/README.md
tedious / msnodesqlv8 ドライバーの違い・追加オプションを知りたいdriversreferences/drivers/README.md
ConnectionPool の作成・イベント・プロパティを調べたいconnectionsreferences/connections/README.md
接続文字列のパース (parseConnectionString) を知りたいconnectionsreferences/connections/README.md
クエリ実行・sql.query タグ付きテンプレート・バルク挿入を知りたいrequestsreferences/requests/README.md
ストアドプロシージャの入出力パラメーターを扱いたいrequestsreferences/requests/README.md
トランザクション・isolation level・commit/rollback を扱いたいtransactionsreferences/transactions/README.md
prepared statement を用意・実行したいtransactionsreferences/transactions/README.md
SQL Server データ型・TVP・JSON/Geography 結果を扱いたいdata-types-resultsreferences/data-types-results/README.md
クエリ結果の recordset / rowsAffected / metadata を調べたいdata-types-resultsreferences/data-types-results/README.md
エラークラス・エラーコード・SQL インジェクション対策を知りたいerrors-diagnosticsreferences/errors-diagnostics/README.md
パラメーター名・列名・型名・プロシージャ名の識別子検証 (EINJECT) を知りたいerrors-diagnosticsreferences/errors-diagnostics/README.md
Diagnostics Channel での OpenTelemetry トレーシングを知りたいerrors-diagnosticsreferences/errors-diagnostics/README.md
旧バージョンからの破壊的変更を確認したいmigrationreferences/migration/README.md
典型的な使い方を知りたいsamplessamples/README.md
インストール・CLI コマンドを知りたいscriptsscripts/README.md

리뷰

아직 리뷰가 없습니다. 사용해 본 소감을 남겨 주세요.

댓글

로그인 없이 쓸 수 있습니다. 사용 후기, 질문, 작동하지 않은 환경 등을 편하게 남겨 주세요.

아직 댓글이 없습니다. 첫 댓글을 남겨 보세요.

보내면 바로 공개됩니다. 이메일 주소나 전화번호 같은 개인 정보는 쓰지 마세요. URL은 2개까지입니다.

0 / 1,000자

이 양식은 reCAPTCHA로 보호되며 Google 개인정보처리방침 및 서비스 약관이 적용됩니다.

같은 저장소의 스킬

amd-rocm

무료

AMD ROCm / HIP GPU コンピューティングリファレンス。 hipMalloc, hipLaunchKernelGGL, HIP Graph, hipGreenCtx, HIPRTC, hipify, rocBLAS, MIOpen, RCCL, hipThreads, libhipcxx, rocprofv3, amd-smi, rocminfo, TheRock / Core SDK 10, CDNA1-4 / RDNA1-4, MI300 / MI350 / MI350P, gfx942, Matrix Core, wave32/64。

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Fandhe-AI/agent-reference-skills42026년 10월 18일 업데이트

Android アプリ開発 (Kotlin) の推奨アーキテクチャリファレンス。 Jetpack, androidx, UI layer, Domain layer, Data layer, state holder, UDF, SSOT, オフラインファースト, モジュール化, ViewModel, viewModelScope, SavedStateHandle, Lifecycle, repeatOnLifecycle, collectAsStateWithLifecycle, LiveData, Hilt による DI, Paging 3 によるページング処理。

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Fandhe-AI/agent-reference-skills42026년 10월 18일 업데이트

Android アプリ開発 (Kotlin) のバックグラウンド・非同期処理リファレンス。 Jetpack androidx WorkManager: Worker, CoroutineWorker, WorkRequest, Constraints, WorkInfo, WorkContinuation, expedited work, テスト。 Service: フォアグラウンドサービス, バウンドサービス, AIDL, Messenger。 AlarmManager, PendingIntent, BroadcastReceiver, JobScheduler, Doze。 Kotlin コルーチン, Flow, StateFlow, SharedFlow, Channel。

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Fandhe-AI/agent-reference-skills42026년 10월 18일 업데이트

Android アプリ開発 (Kotlin) の Gradle ビルドシステムリファレンス。 Android Gradle Plugin (AGP), Kotlin DSL (build.gradle.kts), version catalog, KSP, R8/ProGuard, App Bundle, baseline profile。

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Fandhe-AI/agent-reference-skills42026년 10월 18일 업데이트

Android Jetpack Compose (Kotlin) の androidx Material3 コンポーネントリファレンス。 Button, IconButton, FloatingActionButton, Checkbox, Switch, Slider, TextField, SearchBar, DropdownMenu, Chip, DatePicker, TimePicker, Card, Scaffold, Dialog, BottomSheet, TopAppBar, NavigationBar, NavigationRail, Tab, Snackbar, ProgressIndicator, Badge, Icon, MaterialTheme, ColorScheme, Typography, Shapes。

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Fandhe-AI/agent-reference-skills42026년 10월 18일 업데이트

Android Jetpack Compose (Kotlin) のアニメーション・描画リファレンス。 androidx.compose.animation / graphics API。 AnimatedVisibility, AnimatedContent, animate*AsState, Animatable, AnimationSpec, Canvas, DrawScope, Brush, Path, Color, Image。

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Fandhe-AI/agent-reference-skills42026년 10월 18일 업데이트

Fandhe-AI의 스킬 모두 보기

이 스킬의 문제 신고