NewApp Monitoring is liveSign up free
AgentbeamBeta
Open-source package vulnerability · npm

CVE-2023-50718: NocoDB SQL Injection vulnerability

mediumCVSS 3.1 6.5GHSA-8fxg-mr34-jqr8

Summary --- An authenticated attacker with create access could conduct a SQL Injection attack on MySQL DB using unescaped tablename. Details --- SQL Injection vulnerability occurs in VitessClient.ts. The variable ${args.tn} refers to the table name entered by the user.

Published May 13, 2024 · Updated Aug 21, 2025

Affected packages

nocodb

Ecosystem
npm
Affected
<= 0.202.9
Fixed in
0.202.10
Check
npm ls nocodb

Advisory details

From the GitHub Advisory Database (CC BY 4.0).

Summary

--- An authenticated attacker with create access could conduct a SQL Injection attack on MySQL DB using unescaped table_name.

Details

---

SQL Injection vulnerability occurs in VitessClient.ts.

async columnList(args: any = {}) {
    const func = this.columnList.name;
    const result = new Result();
    log.api(`${func}:args:`, args);

    try {
      args.databaseName = this.connectionConfig.connection.database;

      const response = await this.sqlClient.raw(
        `select *, table_name as tn from information_schema.columns where table_name = '${args.tn}' ORDER by ordinal_position`,
      );

The variable ${args.tn} refers to the table name entered by the user. A malicious attacker can escape the existing query by including a special character (') in the table name and insert and execute a new arbitrary SQL query.

Impact

--- This vulnerability may result in leakage of sensitive data in the database.

Credited to pyozzi-toss.

References

How this page is made: the data panel comes from the GitHub Advisory Database, CISA’s KEV catalog, the NVD and FIRST EPSS, and updates twice a day. No analysis has been written for this entry yet. Methodology

More npm vulnerabilities

All npm entries